topic AW:Too many relationships between tables in QlikView

Too many relationships between tables

Sun, 10 Apr 2011 16:14:34 GMT

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.

AW:Too many relationships between tables

Sun, 10 Apr 2011 16:40:41 GMT

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

AW:Too many relationships between tables

Sun, 10 Apr 2011 16:43:38 GMT

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

Too many relationships between tables

Sun, 10 Apr 2011 20:01:19 GMT

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