Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am doing a simple load of data from one table to another as follow:
Table2:
Load
Field1,
Field2,
Field1 & '/' & Field2 as Field3
Resident Table1;
Table3:
Load Distinct *
Resident Table2;
When I reference my script later in the code, I get an error saying that Table3 can not be found.
When I reference Table 3 later in the code, I get an error saying that Table3 can not be found.
Hi,
As the fields in Table3 are exactly the same as in Table2 Qlik would concatenate into Table2
Use NoConcatenate
I hope this helps,
Cheers,
Luis
Table3:
NoConcatenate
Load Distinct *
Resident Table2;