topic Re: Help in a script in QlikView

Help in a script

kazana — Sat, 02 Jul 2022 13:42:49 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

charishma01 — Sat, 02 Jul 2022 17:37:23 GMT

below the table write a resident load

Re: Help in a script

sidhiq91 — Sun, 03 Jul 2022 02:38:05 GMT

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