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.
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.
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.
