topic Re: Store into if "value" in QlikView

Store into if "value"

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

Hello,

I want to make different files depending on field value. Is this possible?

Final:

Load*,
If(Exists(Akgid), Akgid, 'Null') as TestMatch
;

Load
VDBArtikel,
EAN,
Merk,
Maat,
Season,
Bruto,
Netto,
Akgid
Resident Ban
;

If TestMatch = 'Null' then store into file1.txt

Else store into file2.txt

Re: Store into if "value"

marcus_malinow — Thu, 13 Dec 2018 11:20:18 GMT

This is possible, however there is an issue with your exists clause. Given that all possible values of Akgid already exist in 'Ban', you won't end up with any 'Null' values in your resulting table.

Pseudo code to split:

your initial load

then

resident load where TestMatch = 'Null'

Store and drop

resident load where TestMatch <> 'Null'

Store and drop

Re: Store into if "value"

mohan_1105 — Thu, 13 Dec 2018 11:26:54 GMT

Hi,

Sure you can store the data in a different name. Try this,

Tab1:

Load *,

From table1

where match(Field Name. 'Akgid')

Store Tab1 into [Lib: Loaction\Tab1.qvd];

Drop table Tab1;

Tab2:

Load *,

From table1

where Field Name <> 'Akgid';

Store Tab2 into [Lib: Loaction\Tab2.qvd];

Re: Store into if "value"

bramvdpoel — Thu, 13 Dec 2018 12:42:58 GMT

Loading with TestMatch did not work but this gave me the solution though:

Bekend:

Load
VDBArtikel,
EAN,
Merk,
Maat,
Season,
Bruto,
Netto,
Akgid
Resident Ban
Where Exists(Akgid);

Store * from Bekend into vdban.txt (delimiter is ';', txt);

Drop table Bekend;

It works now.

Thanks a lot!