Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
can you share sample data ?
Regards,
Aditya