topic Concatenate qualified table in QlikView

Concatenate qualified table

Fri, 21 Aug 2009 20:53:38 GMT

Hi,

I'm loading the tables in my app qualified.
Data is loaded in a for loop because I have several Where conditions:

For i=0 to $(myvar)

Sales:
LOAD *;

SQL SELECT *
FROM Sales WHERE field Like '$(myvar)';

next

Unfortunatley concatenating with qualified table isn't working 😞
is there another possible solution than removing qualified load for this table?

Thanks for your help.

Concatenate qualified table

Fri, 21 Aug 2009 21:09:53 GMT

Sorry, but may be I don't understand your issue, and probably my comment may not help you. But let me try.

If you need to concatenate several LOADs into the same table, even with QUALIFY statement affecting it, try to create your table outside your loop, and use explicit CONCATENATE clause in LOAD statement. Something like:

Sales:

LOAD

for ...

CONCATENATE (Sales) LOAD ...

Null() as [Any field that you want really create in your table] AUTOGENERATE 0;

Concatenate qualified table

Fri, 21 Aug 2009 21:13:16 GMT

Sorry, my post goes wrong... I'm posting again

Sales:
LOAD Null() as [Any field that you want really create in your table]
AUTOGENERATE 0; // just to create your table, without any data

for ...
CONCATENATE (Sales) LOAD ...
next