topic Get only specific columns from workbook in Power Query

Get only specific columns from workbook

jaryszek — Fri, 28 Jan 2022 09:28:33 GMT

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

BA_Pete — Fri, 28 Jan 2022 09:59:59 GMT

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

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

Pete

AlexisOlson — Fri, 28 Jan 2022 17:04:55 GMT

Indeed.

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

jaryszek — Mon, 31 Jan 2022 06:34:56 GMT

Thank you !

jaryszek — Wed, 13 Apr 2022 13:29:03 GMT

Hi Guys,

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

Best,
Jacek