Forum Discussion

Dicken's avatar
Dicken
Icon for Post Prodigy rankPost 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")

     

AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
2 years ago

 

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

 

Dicken's avatar
Dicken
Icon for Post Prodigy rankPost 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) 
) )