Table SelectRows with multiple conditions: each List contains

[Anonymous]

Dear community member,

does anyone know if it is possible to use Table. SelectRows function with multiple each List.Contains clauses that returns the value based on several lists. I try to get the data that filtered by list A, list B and another condition. The source table is the same, so I used steps as below

step 1: Table. SelectRows( source_table, each List.Contains(List A, [columnA]))

step 2: Table. SelectRows(source_table, each List.Contains(List B,[columnB]))

step 3: Table. SelectRows(source_table, each List.Contains(List B,[columnC]))

step 4: Table.SelectRows(source_table,[columnB]=[columnC] )

however, only one of step will be applied. If step 4 is applied, my data will not be filtered by Step 1 to Step 3.

Any suggestions for combining the conditions?

Thank you all in advance

Best regards,

Chiao

[HotChilli · Accepted solution]

Assuming that the syntax is correct and each step does what it's supposed to do:

Do you want to 1) apply each step successively to filter the dataset or 2) do you want to filter the dataset with 4 queries and then "union" the results

If 1) -> Each step is being given the same source_table, if you want to have each step applied on the previous step the code has to refer to the previous named stage. The stages are named in Advanced Editor so replace source_table with the previous step name.

If 2)-> You can use the Table.Combine syntax

[Anonymous]

Hello HotChilli,

Thank you so much!

I want to apply the steps successively to filter the data.

The problem is solved!