Concatenate qualified table

[#1]

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.

[#2]

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

next

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

[#3]

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