Help in a script

[kusatvaky]

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

[ajaykakkar93]

You can flag using Applymap, below is a simple example

[ApplyMap T1]:
mapping // important to add
Load * Inline [
ApplyMap Sales Rep Name,ApplyMap Sales Rep Salary
Amit,25000
Sukhi,21000
Ankit,20000
];

[ApplyMap T2]:
Load *,
ApplyMap('ApplyMap T1', [ApplyMap Sales Rep Name],'NA') As [ApplyMap Sales Rep Salary];
Load * Inline [
ApplyMap Sales Rep Name,ApplyMap Sales Rep Role
Amit,B2B
Darshan,340B
Sukhi,B2B
Ankit,340B
];


In your case, you need to create a key in both tables & use applymap to get the value 

If the value will match per key then the value will be added into your new column or it will give you NA(not assigned)