Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
dyee4613
Contributor II
Contributor II

Table Associations

Hi.  I'm having a little trouble loading data.  I loaded up my data in the data manager (4 QVD files and 2 excel files) and had it generate a script.  Afterward, I went into the generated script unlocked it and did some basic modifications (reformatting, renaming, eliminating unnecessary column).  This made the report pretty fast all uploading takes less than 30 seconds.  I went back into the data manager and clicked analyze table and sync table and it let me create my associations.  After I made the associations, I started building the report and everything was good.  

I now want to replace one of my excel tables with another QVD file.  So, I added in the upload code in the data editor and removed the excel file.  I click load data and everything works fine.  I go back to data manager and click analyze data.  It goes fine.  Then I get back to sync scripted tables and it loads forever and never finishes.  

Is it possible to just write the association logic in the script editor? I was looking at the autogenerated script and I don't see any join logic.  I'm pretty perplexed.  

I'm sure that isn't enough information so please let me know what other information I need and I can provide it.  Thank you!

 

Edit: Tried to create a new app.  The load script is just the table data.  Same issue, synchronizing scripting tables is super slow.  

Labels (2)
1 Solution

Accepted Solutions
marksouzacosta

Very good question @dyee4613.

Qlik link tables by field names. If different tables have the same field names, those fields will link the tables - we call these natural links, or just links. Ideally you should link tables by a single field. You can use multiple fields, but this will generate a synthetic table. This is not desired, but it is not the end of the world.

You can find a lot of information about Qlik Data Modeling and some free classes in this link:
Loading and transforming data with scripting | Qlik Sense on Windows Help

 

Regards,

Mark Costa

Read more at Data Voyagers - datavoyagers.net

View solution in original post

1 Reply
marksouzacosta

Very good question @dyee4613.

Qlik link tables by field names. If different tables have the same field names, those fields will link the tables - we call these natural links, or just links. Ideally you should link tables by a single field. You can use multiple fields, but this will generate a synthetic table. This is not desired, but it is not the end of the world.

You can find a lot of information about Qlik Data Modeling and some free classes in this link:
Loading and transforming data with scripting | Qlik Sense on Windows Help

 

Regards,

Mark Costa

Read more at Data Voyagers - datavoyagers.net