Append Query

Question

Hi,&nbsp;&nbsp;I have 3 tables(Survey 1,Survey 2,Survey 3) appended in one table, and i want to compare two different&nbsp; conditions from the 2 different columns.&nbsp;Col A&nbsp; &nbsp; Col B&nbsp; &nbsp;Yes&nbsp; &nbsp; &nbsp; &nbsp; Survey1Yes&nbsp; &nbsp; &nbsp; &nbsp; Suvery2No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Survey3&nbsp;I want the users who clicked "Yes" in Survey 1 and Survey 2.&nbsp;&nbsp;Please help !!&nbsp;

ashish_mathur · Answer

Hi,&nbsp;Share the complete dataset.&nbsp; I am sure there is a respondent column as well.&nbsp; Paste a sample and show the expected result.

pinky0404 · Answer

Hello Sir,&nbsp;Thankfs for your reply. Here is the Sample Data set.&nbsp;&nbsp;&nbsp;

ashish_mathur · Answer

Hi&nbsp;Pinky0404,&nbsp;You may refer to my solution here.&nbsp;Hope this helps.

Forum Discussion

Append Query

3 Replies

Related content

Dataflow - Append

Append Queries 3 different data sources

Append Queries Broken?

Append query vs Append query as New

Append Queries and Remove Duplicate