Forum Discussion
Solved
Multiple transformations on a table not yet expanded
Hello all, I have any number of Excelfiles I grab from a Share Point folder. These are filtered down to filename and [table]. Before I can combine them, I need to a) Skip rows and b) Promo...
Hi Hoschi
You can add a step with below code to transform the table column. Then expand it.
= Table.TransformColumns(#"previous step name", {{"Data", each Table.PromoteHeaders(Table.Skip(_,10),[PromoteAllScalars=true])}})Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi Hoschi
You can add a step with below code to transform the table column. Then expand it.
= Table.TransformColumns(#"previous step name", {{"Data", each Table.PromoteHeaders(Table.Skip(_,10),[PromoteAllScalars=true])}})
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hello v-jingzhang
Thank you very much. I promise to use KISS more often in the future.
Best regards
Hoschi