Two Queries into one Table in Webi.
ID CD1
1 A
2 B
ID CD2
1 A
Table:
ID1 CD1 CD2
1 A Y
2 B N
trying to return Yes if the value in qry1 matches value in qry2, but struggling. Likely due to Qualification and\or ‘select a dimension’ after I Merged the ID’s from the two Tables. Would be good to be taken through step by step with screenshots.
Is qry1.ID in qry2.ID.