topic How to dynamically adjust the filed name while loading data into Qlik in QlikView

How to dynamically adjust the filed name while loading data into Qlik

pranaview — Sat, 16 Nov 2024 21:03:39 GMT

Hi everyone,

Problem: My source table kinda looks like this with some dummy data

Now when I load it into qlik, I get Nov,Dec,Jan as fields but when the file will be updated next month, it will have Dec,Jan and Feb which is not present in the original script and I obviously can't keep on changing the script every month. So, I was wondering if there's any way so that I can make a generic load script which can dynamically read the month columns and load into qlik.

Any suggestion or help will be appreciated.

Thanks,

Pranav

Re: How to dynamically adjust the filed name while loading data into Qlik

chrismarlow — Sun, 14 Apr 2019 17:45:22 GMT

Hi Pranav,
You can use crosstable - https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/crosstable.htm - so something like CrossTable (date, value,4) before your load statement, but you should be able to use the import wizard to line it up.
You might also need to tidy up your months/dates & decide what to do with your target and rolling average field.
Cheers,
Chris.

Re: How to dynamically adjust the filed name while loading data into Qlik

pranaview — Tue, 16 Apr 2019 14:11:19 GMT

Hi Chris,
Thanks for pitching in!
I did think about the CrossTable() function but it won't work as I would still need to know which months are present in the updated file when I will try to load the data before i can transpose them using CrossTable().

For now i think i will have to the transpose directly in source file along with some other modifications prior to the load.

Regards,
Pranav