Filter prior to Append

[Anonymous]

I am attempting to append two queries which share the field, 'Stage'.

I only want to incorporate into the appended query rows with certain stages from query 1 and a second set rows with different stages from query 2.

Is there a way to filter the original queries prior to the append?

Would I need to create another 'sub' query for each of the primary queries containing only the stages I want, then append those 2 new/additional queries?

[v-stephen-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[AlexisOlson · Accepted solution]

If you're willing to work in the Advanced Editor a bit, then this isn't too bad.

Try defining the filtered tables first and then using them in Table.Combine:

let
    Opps = Table.SelectRows(#"Opportunity Line Details", each [status] = 9),
    Pipes = Table.SelectRows(Pipeline_Snapshots, each List.Contains({1..8}, [status])),
    Source = Table.Combine({Opps, Pipes})
in
    Source