Table name ignored

arhadisqlik — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Table name ignored

miskinmaz — Fri, 02 Aug 2019 09:37:09 GMT

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

noconcatenate

DATA3:
load *
Resident DATA2 ;

arhadisqlik — Fri, 02 Aug 2019 12:45:37 GMT

Thanks Miskinmaz - it did the trick 🙂

Best regards