Resident Load not Working

[IgorGol]

Hi,

I done some manipulation on Data file (xlsx) , but the last table not loaded when I use : "Load * Resident tbl"

but if I use specific columns like: "Load Column1 Resident tbl" is does work, can anybody explain why?

Example for not working

temp1:
CROSSTABLE ([1.Attribute field],[Hours],12)
LOAD
Column 1,

Column 2,

Column 3 (etc..)

FROM [lib://Folder_Planning_Control/1.xlsx]
(ooxml, embedded labels, header is 2 lines, table is [1]);

temp2:
LOAD

Column 1,

Column 2,

Column 3 (etc..)

RESIDENT temp1;
drop Table temp1;

temp3:
LOAD *
RESIDENT temp2;

[Taoufiq_Zarra]

can you test noconcatenate after table name

for example :

temp2:

noconcatenate

load *

...

and then drop table temp1

[Digvijay_Singh]

As suggested before Qlik concatenate the data in the first table if all the columns have the same name in the first and second table.

Using noconcatenate forces Qlik to override the default feature and create separate table. But mostly after creating second table we delete the previous table so that it won't create synthetic key due to having more than one field having same names between two tables.

Thanks,

DJ