I am trying this in Qlik Sense.
Resident Table 1;
Drop Table Table1;
In Data model, No Table found.
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...
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??
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.
Retrieving data ...