Resident Load issue

siddharth_kulka — Thu, 05 Aug 2010 14:47:52 GMT

Hi,

Please consider below example:

Temp:

LOAD

a,b from x.xls;

LOAD

a,b from y.xls;

Final:

Load *

RESIDENT Temp;

Drop table Temp;

This results in no tables in the datamodel after the reload. I understand that the table first gets concatenated and then dropped(which is so very not required).

During the resident load, if I edit a field name by renaming it, or insert another field, it works, but I don't want to do that (As it is not the best way of solvong this issue)

Can any one suggest a better solution?

Expected: A new table Final should be seen with 2 fields A,B

Thanks,

Siddharth

Resident Load issue

mike_garcia — Thu, 05 Aug 2010 14:52:21 GMT

Hi,

Use the keyword NoConcatenate before the third Load Statement.

Mike.

Resident Load issue

siddharth_kulka — Thu, 05 Aug 2010 15:20:23 GMT

Thanks Mike,

Not sure, how i missed it!

Siddharth

topic Resident Load issue in QlikView

Resident Load issue

Resident Load issue

Resident Load issue