Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
4 years ago
Solved

Get only specific columns from workbook

Hi Guys,   i am using this function:     Excel.CurrentWorkbook(){[Name="Table322"]}[Content]     ti get full table. How can i get specific columns, like "Col1" and "Col2" from this funct...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi jaryszek ,

     

    Just wrap the whole table reference in a Table.SelectColumns function:

    = Table.SelectColumns(
    Excel.CurrentWorkbook(){[Name="Table322"]}[Content],
    {"columnName1", "columnName2"}
)

     

    Pete

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
4 years ago

Hi Guys,

one more question, can provide instead of column name, column index? 

Best,
Jacek