Most of these have been a bugbear of mine since my early days of QlikView, but I wish that the script logs (as downloaded from QMC / saved on the disk) would include the following:
- Whether an optimised load was used - this shows when you reload in the DLE, so why can't it be recorded in the script logs?
- Show if an alternative table name was created - e.g. when you end up with a "Fact-1" table when you said you wanted it loaded into the "Fact" table - again, this shows in the DLE load window, so why not in the logs?
- Show the filename being loaded during a *-based load - the script section is repeated and the system must know which file is being loaded so why can't this be logged? Could be shown after the literal script as you see for some other things in QS where it interprets folder-based data connections to actual paths.
- Show the missing applymap name - at the moment it just says there was a missing map_id but it doesn't tell you which one. It's common to have a few / many applymaps when modelling data, so knowing which is causing the problem would be very useful (even if it's only the first missing one)!
- Similarly if you have a duplicated field name, it doesn't tell you which is duplicated - would be really helpful to say which field was duplicated (even if you only show the first duplicate if there is more than one!).
It doesn't feel like any of those should be that challenging to do - is there any chance of them being put in place to assist us?
Qlik Partner Ambassador 2024