Forum Discussion

jaryszek's avatar
jaryszek
Super 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

BA_Pete's avatar
BA_Pete
Super User
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

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

Indeed.

 

jaryszek This is the same function that will be used if you use the Choose Columns button in the ribbon.