Tables not found in Data Model Qlik Sense

[rpavan17]

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

[dapostolopoylos]

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;

[rpavan17]

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.

[dapostolopoylos]

You must have ommited the Drop Table Statement, that's because you have two tables created.

Do you need both tables?

[rpavan17]

I have to Concatenate output  of two resident tables after few calculations. So, i cannot drop one table.

[dapostolopoylos]

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

[PrashantSangle]

can you share your script??

Regards

[ChennaiahNallani]

Table 1:

Load

A1,A2, A3

from ....(qvd)

Table 2:

Qualify *;

Load

A1,A2,A3

Resident Table 1;

Unqualify *;

Drop Table Table1;

[rpavan17]

Hi,

Any solution other than qualify*.

May i know why NOCONCATENATE joining the tables if there are same fields.

[PrashantSangle]

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,