Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

siddharth_kulka
Contributor II

Resident Load issue

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

Tags (2)
1 Solution

Accepted Solutions
mike_garcia
Valued Contributor

Resident Load issue

Hi,

Use the keyword NoConcatenate before the third Load Statement.

Mike.

Miguel García
Qlik Expert, Author and Trainer
2 Replies
mike_garcia
Valued Contributor

Resident Load issue

Hi,

Use the keyword NoConcatenate before the third Load Statement.

Mike.

Miguel García
Qlik Expert, Author and Trainer
siddharth_kulka
Contributor II

Resident Load issue

Thanks Mike,

Not sure, how i missed it!

Siddharth