Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter prior to Append

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 st...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    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
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

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