Help

Is it possible to write an AirTable version of this power query?

Topic Labels: Formulas
Solved
Jump to Solution
821 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Terilyn_Floyd-C
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
Terilyn_Floyd-C
4 - Data Explorer
4 - Data Explorer

I found a solution that works in the published scripts. “Create record from multiple select”

See Solution in Thread

1 Reply 1
Terilyn_Floyd-C
4 - Data Explorer
4 - Data Explorer

I found a solution that works in the published scripts. “Create record from multiple select”