Help in a script

[kazana]

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

[charishma01]

below the table write a resident load

[sidhiq91]

@kazana  Please see the below script that I have written in the Script Editor, please use the same idea to get the desired output. Also I have attached the Screen shot of the output, the Null values indicate the Policy ID's and Endorsement ID's present in table 1 but not in table 2. 

Table1:
Load
Autonumber(PolicyID&''&EndorsementID1) as ID,
EndorsementID2
Inline [
PolicyID, EndorsementID1, EndorsementID2
1,E001,ED001
2,E002,ED002
3,E003,ED003
4,E004,ED004
5,E005,ED005
];

Left join (Table1)
Table2:
Load AutoNumber(PolicyID&''&EndorsementID1) as ID,
PolicyID as PolicyID2,
EndorsementID1 as EndorsementID12
Inline [
PolicyID, EndorsementID1
1,E001,ED001
2,E002,ED002
3,E003,ED003
6,E006,ED006
];

Exit Script;

If this resolves your issue, please like and accept it as solution.