Forum Discussion

Dicken's avatar
Dicken
Post Prodigy
2 years ago
Solved

Filter Table , Column by postion

  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...
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago

     

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

     

Dicken's avatar
Dicken
Post Prodigy
2 years ago

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's avatar
AlienSx
Super User
2 years ago

 

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

 

  • Dicken's avatar
    Dicken
    Post Prodigy
    2 years ago

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

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

     

  • Dicken's avatar
    Dicken
    Post Prodigy
    2 years ago

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

    Richad.