Dynamic column expand

[mariopavic]

Hi all,

I want to expand records column dinamically. Here is the code:

toExpand = Table.ExpandRecordColumn(#"Table to expand", "newColumn name", ListOfNamesToExpand) // ListOfRecords contains a list with text values of each column to expand

If I do this from UI it takes 2 seconds to expand all rows, but I want to expand it dinamically because data can change upon refresh. When I use the code it takes around 6h for 250 results. Is there a faster way to do this or I'm doing something wrong?

Thanks in advance,

Mario 

[mariopavic · Accepted solution]

I didn't compare old vs new code but new one is way faster:

convertToList= Record.FieldNames(Record.Combine(List.Select(Table.Column(#"Removed Other Columns","newColumnName"), each _ <> "" and _ <> null))), 
ListOfNamesToExpand = Table.ExpandRecordColumn( #"Removed Other Columns","newColumnName", convertToList),

The problem was in creating the actual list.