Append Query

[Pinky0404]

Hi, 

I have 3 tables(Survey 1,Survey 2,Survey 3) appended in one table, and i want to compare two different  conditions from the 2 different columns.

Col A    Col B   

Yes        Survey1

Yes        Suvery2

No         Survey3

I want the users who clicked "Yes" in Survey 1 and Survey 2.  

Please help !!

[Ashish_Mathur]

Hi,

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

[Pinky0404]

Hello Sir,

Thankfs for your reply. Here is the Sample Data set.

[Ashish_Mathur]

Hi @Pinky0404,

You may refer to my solution here.

Hope this helps.