Too many relationships between tables

[#1]

Dear all,

Hope somebody can help me with this. I am rather new to Qlikview...

I am loading 3 tables from a MySQL Drupal DB which goes fine until I try to do anything with it. The issue seems to be that QV creates a lot of relationships between tables which I do not need ($syn XX table etc.). How can I prevent this and make my own relations?

Thanks.

[#2]

Hello zeeforel,

QV links tables during the load together with same fieldnames (case sensitive). If you have two source-tables with three matching fieldnames it will generate a so called sync-table including these fields.

This is a very comfortable and fast way to build a QV-datamodell, but you have to understand the details. If you do not want to link tables together you can rename the corresponding fields using the keyword "AS" in your load-statement. This is similar to SQL-Syntax. For more see Online-Help and.or your Manuals.

HtH for the first steps

Roland

[#3]

Thanks for the info Roland. Going to have a look at the docs.

[#4]

Or you can use Qualify(). See it on F1