Automatic column header of the output table (records in records)

[julhelp]

hi,

I managed to output the headings of the columns variably for the first time. The Problem now is, that in these records there are another records.

Is there also a possibility, if in the output table there are still several columns with records to output them also variably? Or do i have to output them step by step?

Maybe I can handle it with a sort of loop?

thanks in advance

[Anonymous]

I'd normally handle this by first adding a step to get the column names that you need:

ColumnNames = Table.ColumnNames(TableOrPriorStepName)

This gives you your list of ColumnNames. Once you are ready to replace your ColumnNames, you can use List.Zip with Table.ReplaceColumnNames:

ReplaceColumns = let ReplaceThese = Table.ColumnNames(PriorStepOrTableName) in Table.ReplaceColumnNames(PriorStepOrTableName, each List.Zip({ReplaceThese, ColumnNames}))

--Nate