Forum Discussion
Transforming Multiple Header file
Hi baptiste23 ,
The code:
Table.Transpose(Table.CombineColumns(Table.Transpose(Table.FirstN(#"Filtered Rows", 2)),{"Column1", "Column2"},Combiner.CombineTextByDelimiter(" - ", QuoteStyle.None),"Merged")),
Merges the 2 first rows in one, so you can handle the headers.
the code "Table.Skip(#"Filtered Rows", 2)" skips the first 2 rows (they are handled on the code above).
Table.Combine just appends them.
Hi camargos88
Thank you very much for the answer. It seems really interesting and I think I will be able to get hat I needed.
There is just one step that I don't understand:
TableResult = Table.Combine(
{
Table.Transpose(Table.CombineColumns(Table.Transpose(Table.FirstN(#"Filtered Rows", 2)),{"Column1", "Column2"},Combiner.CombineTextByDelimiter(" - ", QuoteStyle.None),"Merged")),
Table.Skip(#"Filtered Rows", 2)
}
)
Could you please give me more detail the transformation realised by this step so I can do it by myself?
Thank you for the help provided
Best
B
Community ChampionHi baptiste23 ,
The code:
Table.Transpose(Table.CombineColumns(Table.Transpose(Table.FirstN(#"Filtered Rows", 2)),{"Column1", "Column2"},Combiner.CombineTextByDelimiter(" - ", QuoteStyle.None),"Merged")),
Merges the 2 first rows in one, so you can handle the headers.
the code "Table.Skip(#"Filtered Rows", 2)" skips the first 2 rows (they are handled on the code above).
Table.Combine just appends them.