topic Re: Help in a script in QlikView

Help in a script

kihastyga — Fri, 23 Sep 2022 07:12:05 GMT

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

Re: Help in a script

BrunPierre — Fri, 23 Sep 2022 11:03:53 GMT

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