Forum Discussion

Mahmed1's avatar
Mahmed1
Helper IV
2 years ago
Solved

Not text starts with

Hi   what is the best way to have a table where i can have an exemption list but in the mcode have it look at this table to filter out all the codes that does not start with everything in this tabl...
  • AlienSx's avatar
    2 years ago

    Hi, Mahmed1 

     

            Table.SelectRows(
                your_table, 
                (x) => 
                not List.AnyTrue(
                        List.Transform(
                            exemption_list, 
                            (t) => Text.StartsWith(x[code], t)
                        )
                    )
            )

     

    but exemption_list must be a list, not table. I hope you know how to get a list from a column of your table. And buffer this list before usage (outside of Table.SelectRows).