Table name ignored

[arhadisqlik]

Hi there - I am fairly new to Qlikview and have run into a problem that puzzles me. Hope someone can clarify:

I have the following code:

Temp:
load
Field1, Field2,Field3
Resident ExcelDetails ;

DATA3:
load *
Resident DATA2 ;    // <--DATA2 is a table created in a previous tab 

left join(DATA3)
load *
resident Temp;

But when it creates the table DATA3 the name is ignored and the table is labeled DATA2 instead - in debugging it looks like this:

Temp << ExcelDetails 10 lines fetched

DATA2 << DATA2 20 lines fetched

The result is an error when trying to join to DATA3 because it does not exist.

Could anybody explain to me what goes wrong?

Thanks in advance

[miskinmaz · Accepted solution]

while taking the resident of table 2 try to use noconcatenate like 

noconcatenate

DATA3:
load *
Resident DATA2 ; 

[arhadisqlik]

Thanks Miskinmaz - it did the trick 🙂 

Best regards