Skip to content

Instantly share code, notes, and snippets.

@whitemx
Created April 23, 2015 09:38
Show Gist options
  • Save whitemx/04dcc407c1c5a6ee6d81 to your computer and use it in GitHub Desktop.
Save whitemx/04dcc407c1c5a6ee6d81 to your computer and use it in GitHub Desktop.
let
PageRange = {1..100},
Source = List.Transform(PageRange, each try {_, fnGetCollectionData(_)} otherwise null),
First = List.FirstN(Source, each _ <> null),
Table = Table.FromRows(First, {"Page", "Column1"}),
split = Splitter.SplitTextByDelimiter(","),
fieldnames = split(fnGetParameter("fields")),
Expanded = Table.ExpandTableColumn(Table, "Column1", fieldnames)
in
Expanded
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment