Skip to main content
Solved

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

  • February 4, 2022
  • 1 reply
  • 16 views

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

Best answer by Terilyn_Floyd-C

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

1 reply

  • Author
  • New Participant
  • Answer
  • February 7, 2022

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