Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Thanks for the info Roland. Going to have a look at the docs.
Or you can use Qualify(). See it on F1