Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone, Im a begineer in qlikview. I have 2 tables, in the table 1 I have Policy ID and two different endorsement IDs, in the other table I have Policy ID and just one endorsement ID. How can I search for the policies that are in the table 1 but aren’t in the table 2. Using the combinations of Policy and enforsement.
Thanks!!
I'd do something as below.
PolicyMappingTable:
LOAD [Policy ID], [Policy ID]
FROM YourTable2;
Table1:
LOAD [Policy ID],
[Endoresment ID],
ApplyMap('PolicyMappingTable',[Policy ID], '#') as Flag
FROM YourTable1
where ApplyMap('PolicyMappingTable', [Policy ID],'#')='#';