Resident Load issue

[siddharth_kulka]

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

[mike_garcia · Accepted solution]

Hi,

Use the keyword NoConcatenate before the third Load Statement.

Mike.

[siddharth_kulka]

Thanks Mike,

Not sure, how i missed it!

Siddharth