Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
while taking the resident of table 2 try to use noconcatenate like
noconcatenate
DATA3:
load *
Resident DATA2 ;
while taking the resident of table 2 try to use noconcatenate like
noconcatenate
DATA3:
load *
Resident DATA2 ;
Thanks Miskinmaz - it did the trick 🙂
Best regards