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 function?

Best,
Jacek

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

4 Replies

  • 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

  • jaryszek's avatar
    jaryszek
    Super User
    4 years ago

    Hi Guys,

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

    Best,
    Jacek