Filter Table , Column by postion

[Dicken]

Hi, 

  so filter table ;

Table.SelectRows(Source , each ([B] = "A"))

but if I do not know the name of a coliumn, just postion, so I know I need column 2 , so I found the name; 

 ( List.Transform( {1}, 
(A)=> Table.ColumnNames( Source ) {A} ) {0} )

So this is giving me the column name as text, but how to I get into the select rows as a column , Table.Column = a list, 

 List.Transform( 
 Table.Column ( Source , colname ), 
 (A)=> A = "A")

So is there a way to get colname  step which is text into the equivalent of  [ column name]  ? 

Richard. 

[Dicken]

I have done a bit more and come up with this; 

 (List.Transform( {1}, (A)=> 
Table.ColumnNames( Source){A} ){0})

To get column name, then 

 Table.SelectRows(Source, each  
List.Contains( {"A"},Record.Field(_, columnName) 
) )

If anyone have more ideas pleas let me know. 

Richard. 

[AlienSx · Accepted solution]

Table.SelectRows(Source, each Record.FieldValues(_){1} = "A")

[Dicken]

Actually, it's a bit different, and simpler thnks again, 

Richad. 

[Dicken]

Thats similar to my updated post exccep i used record.field, thanks anyway, 

 Table.SelectRows(Source, each  
List.Contains( {"A"},Record.Field(_, columnName) 
) )