Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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