Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have some 2000 files loaded pertaining to different companies and periods. I have got the filenames loaded with the function filename(). Now if I made some change in one file out of the 2000 in the folder, is there any way to relaod only that one file?
Thanks
SAK
Yes, but then your qlikview document would contain only the data from that one file and not the other 1999 files. That's probably not what you want. What you can do is something like this:
For the first load:
1. load all the source files
2. store the tables into qvd's
3. move the processed source files to another folder
For every next reload:
1. load the qvd's
2. load any new source files
3. store the tables into qvd's
4. move the new processed source files to another folder
After the first time you'll always load all the previous data from the qvd's but since these can be optimized loads they'll be very fast. If you update a file you simply place it again in the folder used for files that should be loaded and do a reload.
You could also try partial reload, but that may be more trouble than it's worth. See here if you want an example.