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!
