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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Gabe_V
Helper I
Helper I

Record.Field with underscore returns: "The name '_' wasn't recognized."

I am trying to remove a set of columns from a table by their index/position as opposed to the column name, because the column names can vary from month to month. I am using the code below, derived from a similar method I used before with the Table.AddColumn function (with no issues), but now when I try to use it in the Table.RemoveColumns function I get this error: "Expression.Error: The name '_' wasn't recognized. Make sure it's spelled correctly." Can anyone help explain why the underscore doesn't work in this instance, and what I should use instead? Thanks in advance!

 

#"Removed Columns1" = Table.RemoveColumns(
Source,
{
each Record.Field(_, Table.ColumnNames(Source){12}),
Record.Field(_, Table.ColumnNames(Source){14}),
Record.Field(_, Table.ColumnNames(Source){16})
},
MissingField.Ignore
)

 

 

1 ACCEPTED SOLUTION
ppm1
Solution Sage
Solution Sage

Try this instead:

 

#"Removed Columns1" = Table.RemoveColumns(
Source,
{
Table.ColumnNames(Source){12},
Table.ColumnNames(Source){14},
Table.ColumnNames(Source){16}
},
MissingField.Ignore
)

 

Pat

Microsoft Employee

View solution in original post

2 REPLIES 2
ppm1
Solution Sage
Solution Sage

Try this instead:

 

#"Removed Columns1" = Table.RemoveColumns(
Source,
{
Table.ColumnNames(Source){12},
Table.ColumnNames(Source){14},
Table.ColumnNames(Source){16}
},
MissingField.Ignore
)

 

Pat

Microsoft Employee

Well how about that! It works perfectly! However, it does kind of make me wonder why the Record.Field was needed in my previous Table.AddColumn query, because I had initially tried that one with just using Table.ColumnNames and it failed. I suppose that musing is for another day though. Thank you so much for your quick help! Cheers!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.