Forum Discussion

suji's avatar
suji
Icon for Advocate I rankAdvocate I
9 years ago
Solved

How to display Intersect and except data of two tables

Hi ,   Need help from you on below . I have two table's A and B. There is a common column "id" in A and B. Below is the sample data for ex, A id   Name  age -------------------- 1    aaa   ...
Need Help
  • suji's avatar
    suji
    9 years ago

    Hi Feldmann & Marcel,

     

    Thanks for your quick response.

    today i tried using Append queries option. I appended Table A and Table B and created a new table. After that i created a new custom column to know the record from which table.  It is working exactly what i want.

     

     

    Thanks & Regards,

    Suresh Peddirsi.

     

thiyageshwarans's avatar
thiyageshwarans
Frequent Visitor
8 years ago

Hi All,

 

Need help from you on below

 

I have a table A. i want to compae the data with the table using  different provider.

 

Example 1

 

select the provider AA and BB in the slicer, output should show only 0001 and 0002 records.

 

Example 2

 

select the provider AA and CC in the slicer, output should show only 0001 records.

 

Example 3

 

select the provider BB and CC in the slicer, output should show only 0001 and 0004 records.

 

Below is the Sample Data for ex.

 

ID, Provider, Postal

--------------------

1   AA           0001

2   AA           0002

3   AA           0005

4   BB            0001

5   BB            0002

6   BB            0004

7   CC            0001

9   CC            0004