Forum Discussion
Solved
Dynamic column expand
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
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.
1 Reply
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.