Forum Discussion

philongxpct's avatar
philongxpct
Frequent Visitor
9 years ago
Solved

Expand colum problem

I working on a project that have multi columns data from multi excel files. User must declare what columns to keep from sample fisrt N rows of data and don't care about headers, just column1, column2...
Need Help
  • philongxpct's avatar
    philongxpct
    9 years ago

    Great, thanks you v-lvzhan-msft, not exact like i looking for but appriciated. I made a parameter ColsToKeep = Table.ToList(tbl1) from Table1 then try #"Expanded tbl2" = Table.ExpandTableColumn(PreviousStep, "tbl2", ColsToKeep, ColsToKeep) . Worked. Thanks again.

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

philongxpct

If what you'd like is to select certain columns from one table based on the columns stored in another table, check 

 

let

    Source = Table.FromRows({{1,2,3,4,5},{1,2,3,4,5},{1,2,3,4,5}},{"col1","col2","col3","col4","col5"}),
    columnListTable = Table.FromRows({{"col1"},{"col2"},{"col3"}},{"column"}),
    
    selectedColumns = Table.SelectColumns(Source,Table.ToList(columnListTable ))
in
    selectedColumns
philongxpct's avatar
philongxpct
Frequent Visitor
9 years ago

Great, thanks you v-lvzhan-msft, not exact like i looking for but appriciated. I made a parameter ColsToKeep = Table.ToList(tbl1) from Table1 then try #"Expanded tbl2" = Table.ExpandTableColumn(PreviousStep, "tbl2", ColsToKeep, ColsToKeep) . Worked. Thanks again.

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    philongxpct

    As your question is solved, if no further questions, you can accept your that reply as solution to close this thread. :)