Feb 04, 2022 11:11 AM
The piece I am really struggling with is the comma delimited split. This is the order as done in power query.
Select entire tab/Table
Source = Excel.CurrentWorkbook(){[Name=“Table1”]}[Content],
#“Changed Type” = Table.TransformColumnTypes(Source,{{Many Columns/Fields}}),
Select only the Columns/Fields
#“Removed Other Columns” = Table.SelectColumns(#“Changed Type”,{“Key”, “ManyLinked”}),
Remove empty cells/rows
#“Filtered Rows” = Table.SelectRows(#“Removed Other Columns”, each ([ManyLinked] <> null)),
Split the ManyLinked into one row for each comma delimitate value - each row gets the value from Key and a single value from ManyLinked
#“Split Column by Delimiter” = Table.ExpandListColumn(Table.TransformColumns(Table.TransformColumnTypes(#“Filtered Rows”, {{“ManyLinked”, type text}}, “en-US”), {{“ManyLinked”, Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), “ManyLinked”),
Thanks, Teri
Solved! Go to Solution.
Feb 07, 2022 07:55 AM
I found a solution that works in the published scripts. “Create record from multiple select”
Feb 07, 2022 07:55 AM
I found a solution that works in the published scripts. “Create record from multiple select”