Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jaryszek
Post Patron
Post Patron

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

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi @jaryszek ,

 

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

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

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

4 REPLIES 4
jaryszek
Post Patron
Post Patron

Hi Guys,

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

Best,
Jacek

BA_Pete
Super User
Super User

Hi @jaryszek ,

 

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

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

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Thank you !

Indeed.

 

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

AlexisOlson_0-1643389473892.png

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors