Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rpavan17
New Contributor II

Tables not found in Data Model Qlik Sense

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

9 Replies
dapostolopoylos
Contributor III

Re: Tables not found in Data Model Qlik Sense

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;

Father/Husband/BI Developer
rpavan17
New Contributor II

Re: Tables not found in Data Model Qlik Sense

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
Contributor III

Re: Tables not found in Data Model Qlik Sense

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

Do you need both tables?

Father/Husband/BI Developer
rpavan17
New Contributor II

Re: Tables not found in Data Model Qlik Sense

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

dapostolopoylos
Contributor III

Re: Tables not found in Data Model Qlik Sense

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

Father/Husband/BI Developer

Re: Tables not found in Data Model Qlik Sense

can you share your script??

Regards

Regards,
Prashant Sangle
ChennaiahNallani
Contributor III

Re: Tables not found in Data Model Qlik Sense

Table 1:

Load

A1,A2, A3

from ....(qvd)

Table 2:

Qualify *;

Load

A1,A2,A3

Resident Table 1;

Unqualify *;

Drop Table Table1;

rpavan17
New Contributor II

Re: Tables not found in Data Model Qlik Sense

Hi,

Any solution other than qualify*.

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

Re: Tables not found in Data Model Qlik Sense

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,

Regards,
Prashant Sangle