Help in a script

[kihastyga]

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!!

[BrunPierre]

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],'#')='#';