Forum Discussion
Mahmed1
2 years agoHelper IV
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...
- 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).