Forum Discussion

KJChin's avatar
KJChin
Frequent Visitor
1 year ago
Solved

Choose Column before Expand Table

I am importing data from multiple excel files in sharepoint folder to Power Query. I would like to define the chosen columns before expand the data. Previously I have defined to take the data of firs...
Need Help
Tips and Tricks
  • slorin's avatar
    slorin
    1 year ago

    Hi KJChin 

     

    ...
    Table.SelectColumns(PromotedHeaders, List.Transform({1, 2, 3, 7}, each Table.ColumnNames(PromotedHeaders){_ - 1}))

     Stéphane

slorin's avatar
slorin
Super User
1 year ago

Hi KJChin 

 

...
Table.SelectColumns(PromotedHeaders, List.Transform({1, 2, 3, 7}, each Table.ColumnNames(PromotedHeaders){_ - 1}))

 Stéphane

KJChin's avatar
KJChin
Frequent Visitor
1 year ago

OMG, IT WORKED! HAHA

Thanks a lot, slorin You are amazing!