Forum Discussion
Solved
expand multiple columns at once
Hi Is it possible to expand for all the columns Grouped_1 and Grouped_2 at once (example in picture)? When trying to do it column by column it is too slow. (In my final structure i will have 10 gr...
potresti provare qualcosa del genere ...
listGrouped=List.Select(Table.ColumnNames(yourab), each ----),
namesColGroupX=[groupe_1={"c11", ---}, groupe_2={"c21", ---}, ...],
List.Accumulate(listGrouped, yourtab, (s,c)=>Table.ExpandTableColumn(s,c, Record.Filed(namesColGroupX,c)))
potresti provare qualcosa del genere ...
listGrouped=List.Select(Table.ColumnNames(yourab), each ----),
namesColGroupX=[groupe_1={"c11", ---}, groupe_2={"c21", ---}, ...],
List.Accumulate(listGrouped, yourtab, (s,c)=>Table.ExpandTableColumn(s,c, Record.Filed(namesColGroupX,c)))