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