Power Query Filter by Column Position not Name

[programsam]

Trying to filter by column position and not column name but am getting a circular reference error. Can anyone assist? Code below...

= Table.SelectRows(#"Promoted Headers", each (Table.ColumnNames(#"AASB"){0} <> null and Table.ColumnNames(#"AASB"){0} <> "AG" and Table.ColumnNames(#"AASB"){0} <> "GBM"))

 

[Matt Allington]

I can’t tell what is causing the circular ref from the code, but the way to solve this issue is to first create a dynamic list of column names, then select the position you want. I normally do this using the UI and a bit of M

add a new manual step
=Table.ColumnNames(PrevStep)

this should give the list of column names
=Table.ColumnNames(PrevStep){2}
this will give you column 3 name

keep this code, then manually rename column 3 from PrevStep (in my example)
after the UI writes the code, remove the hard code ref to the name of column 3 and replace with the code above (which is dynamic)
Table.ColumnNames(PrevStep){2}

 

[programsam]

I can’t tell what is causing the circular ref from the code, but the way to solve this issue is to first create a dynamic list of column names, then select the position you want. I normally do this using the UI and a bit of M

add a new manual step
=Table.ColumnNames(PrevStep)

this should give the list of column names
=Table.ColumnNames(PrevStep){2}
this will give you column 3 name

keep this code, then manually rename column 3 from PrevStep (in my example)
after the UI writes the code, remove the hard code ref to the name of column 3 and replace with the code above (which is dynamic)
Table.ColumnNames(PrevStep){2}

Thanks Matt,

I actually had this code but didn't think to just rename by position before filtering. Appreciate it!