topic Re: Conditional load in QlikView

Conditional load

Anonymous — Fri, 20 Feb 2015 09:47:34 GMT

Hi all,

I'm struggling to solve the following.

Every organisation has an adress type A and some also have an adress type B or ....

I would like to load the adress of all organisations with adress type B and A otherwise.

So I've got the following:

And I would like to load:

I've tried it by using the Match and Minstring function but can't get it to work.

Anyone knows a solution? Would be of great help!!

MK_QSL — Fri, 20 Feb 2015 09:59:08 GMT

Temp:

LOAD * Inline

[

Organisation, Adress type, Adress

1, A, V

1, C, W

1, B, X

2, A, Y

2, C, Z

];

NoConcatenate

Temp2:

Load Distinct Organisation, Organisation as ORGTEMP, [Adress type], Adress Resident Temp Where [Adress type] = 'B';

Concatenate

Load Distinct Organisation, [Adress type], Adress Resident Temp Where NOT Exists (ORGTEMP, Organisation) and [Adress type] = 'A';

Drop Table Temp;

Drop Field ORGTEMP;

Anonymous — Fri, 20 Feb 2015 11:06:56 GMT

Thanx a lot!!!

Changed a little bit in the script. Not working with inline since the file in fact consists of 160.000 lines.

However the lower part seems to function well!

MK_QSL — Fri, 20 Feb 2015 11:44:29 GMT

I have tested with million records here and it's working fine with some different example...

It should work.. Let me know what you have changed in your script !