Help in a script

[YekinKebo]

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

[stevejoyce]

It may depend on how you want to use the resulting set.  But 1 option is to use where exists.  see below for an example

table2:
load *
//create composite key
,policyID & table2.endorsementID as Key;

load * inline [
policyID, table2.endorsementID
1, 100
2, 100
]
;

table1:
load * inline [
policyID, table1.endorsementID
1, 100
1, 200

]
;

table1_NOT_table2:
noconcatenate load *
resident table1
where not exists (Key, policyID & table1.endorsementID)
;

[Chip_Matejowsky]

@YekinKebo
I moved this thread to the QlikView App Development section.

Best Regards

[MarcoWedel]

Hi,

I guess you are looking for a front end solution?

Can you please post some sample data of both tables including only the relevant ID fields?

thanks

Marco