Get only specific columns from workbook

[jaryszek]

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

[jaryszek]

Hi Guys,

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

Best,
Jacek

[BA_Pete · Accepted solution]

Hi @jaryszek ,

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

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

Pete

[jaryszek]

Thank you !

[AlexisOlson]

Indeed.

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