topic Re: remove contracts comparing two files in QlikView

remove contracts comparing two files

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi, everyone

I have two files, "File1" and "File2"

File1:

Contains all contracts

File2:

Contains all contracts that should be excluded

it is possible to remove the contracts in the script?

Example:

All contracts

tab1:

LOAD * Inline [

CONTRACT

];

contracts that should be excluded

tab2:

LOAD * Inline [

CONTRACT

];

Thanks!!

Re: remove contracts comparing two files

sunny_talwar — Mon, 13 Nov 2017 16:16:49 GMT

May be this

tab2:

LOAD * Inline [

CONTRACT

];

tab1:

LOAD * Inline [

CONTRACT

] Where not Exists(CONTRACT);

Re: remove contracts comparing two files

its_anandrjs — Mon, 13 Nov 2017 16:16:49 GMT

Use Where exists.

Re: remove contracts comparing two files

Anil_Babu_Samineni — Mon, 13 Nov 2017 16:18:19 GMT

Where Not Exists(CONTRACT) will achieve

Re: remove contracts comparing two files

its_anandrjs — Mon, 13 Nov 2017 16:32:49 GMT

Do this way based on your table structure

tab2:

LOAD CONTRACT as Exc_CONTRACT;

LOAD * Inline [

CONTRACT

];

tab1:

LOAD * Inline [

CONTRACT

]Where not Exists(Exc_CONTRACT,CONTRACT);

DROP Table tab2;

Find attached