Forum Discussion

Hoschi's avatar
Hoschi
New Member
4 years ago
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...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

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.

Hoschi's avatar
Hoschi
New Member
4 years ago

Hello v-jingzhang

Thank you very much. I promise to use KISS more often in the future.

 

Best regards

Hoschi