Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying this in Qlik Sense.
Table 1:
Load
A1,A2, A3
from ....(qvd)
Table 2:
Load
A1,A2,A3
Resident Table 1;
Drop Table Table1;
In Data model, No Table found.
Kindly help
Your tables are concatenating by default because the have same column names...
Table2 is never created and when you delete Table1 all your data are gone...
Try this:
Table 1:
Load
A1,A2, A3
from ....(qvd)
NoConcatenate
Table 2:
Load
A1,A2,A3
Resident Table 1;
Drop Table Table1;
Hi,
Thanks for reply.
It creates two tables now. But both are joined with all fields.
It should not join. Dont know why the fields are joined from both table by using NoConcatenate though.
You must have ommited the Drop Table Statement, that's because you have two tables created.
Do you need both tables?
I have to Concatenate output of two resident tables after few calculations. So, i cannot drop one table.
You can change the names of the fields in one of two tables so they will not be concatenated.
You can use a QUALIFY/UNQUALIFY statement.
There are many ways to work it out
can you share your script??
Regards
Table 1:
Load
A1,A2, A3
from ....(qvd)
Table 2:
Qualify *;
Load
A1,A2,A3
Resident Table 1;
Unqualify *;
Drop Table Table1;
Hi,
Any solution other than qualify*.
May i know why NOCONCATENATE joining the tables if there are same fields.
Noconcatenate never join the table
It is due qlik engine association feature It will create synthetic table which contain list of common field of both tables.
Regards,