Forum Discussion
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...
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
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