Not text starts with

[Mahmed1]

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 table

ive got code that does it with

each list.contains([code] = tbl_exemption_list)

how can I achieve the same this but replace with text does not start with? At the moment im having to keep adding it manually into power query

[AlienSx]

@Mahmed1 your_table is your prev step

[Mahmed1]

Thank you - ill try and give that a go

Where you put your table, do you mean refer to previous step or the exemption list table?

[Mahmed1]

Thank you

the way i did it was - right click - drill doen column to change to list

that right?

[AlienSx]

basically, yes. 

[AlienSx · Accepted solution]

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).