Display the value that is unique after comparing two columns.

[qliksense-newbie]

Hi Guys, 

How can I show the distinct value of two columns from different sources (BPMId as Id & REQUESTNUMBER as Request no)?

I need to figure out what is missing from table 2 since table 1 has more rows than table 2, even though they suppose to have the same number of rows.

table1:

    Load

                BPMId as Id,

        ClientGroupCode as clientgroup,

        Status as Status,

        SubjectLine as Subject

        From [$(x/portal_support_request.qvd] (qvd)

        WHERE Len(Trim(BPMId))>0;

     table2:

     Load

                REQUESTNUMBER as Request_no,

         CLIENTGROUP,

         STATUS,

         SUBJECTLINE

         From [$(x/request.qvd] (qvd);

 Thank you so much!

[Aditya_Chitale]

can you share sample data ?

Regards,

Aditya