Multiple custom SQL connection to Qlikview

[Anonymous]

I am very new to Qlikview and i have been using tableau till now. I want to make a dashboard which has multiple custom SQL queries. For ex:

Product table+price table as one connection,

Product table+review table as one connection,

Product table+specification table and so on...

These tables will be updated with new data everyday. When i make these connections in Qlikview, it shows as sync and the system is hanging. I think its trying to club all the data connections together. How do i avoid this and keep them as individual data connections?

[Anonymous]

Hello Avinash.

I think you have multiple fields with the same name in different tables and thats why Qlikview makes the synthetic key.

Hope this links clarify it a bit for you.

Synthetic Keys

Best Practices in Data Modeling.pdf

If not please upload your QVW to be able to assist you better.

Regards,

Josefina

[shilpan]

Also make sure that there aren't any Cartesian joins among these tables

[vishsaggi]

Use Qualify and Unqualify keywords.

Connection 1;

Qualify *;

Unqualify KeyIDField;

Table1:

LOAD *

FROM yoursourceTable;

Connection 2;

Qualify *;

Unqualify KeyIDField;

Table2:

LOAD *

FROM yoursourceTable;

Connection 3;

Qualify *;

Unqualify KeyIDField;

Table3:

LOAD *

FROM yoursourceTable;

If this does not help can you paste your actual script you are trying to run.