One of the user requirements is to exclude certain CSV files from loading and those set of files would be selected by the user through Qlikview. They want to have an interface on QlikView with selections for Retailer, Category, Date etc. and once submitted QlikView should refresh immediately and do not load files specified.
I have a large number of CSV files in one directory (no database) and loading all of them through
Load *
satatement
File names do have all the information mentioned above.
Thank you for prompt reply. The scenario that I'm facing is if the user excludes certain files, thos efiles should not load in future. From this example, it looks like they would have to filter out data everytime.
Also, my filter criteria invloves multiple fileds, in this example it is based on only one (i.e. Year), would the logic be different in that case?
You can just keep appending values to the variable instead of just replacing the values like in my example. The variable will then have a list of all files to exclude. This variable can be used on the next reload to skip the unwanted files. My example uses just one field, but that doesn't really matter. You need to create a list of file names and put them in a variable. How many fields you use to determine the file name to exclude is up to you. Of course it's easiest if your users can simply select the file names they've processed.
Yes, basically the same principle. Add the conditions to a variable and use the variable in the where clause for the load statement. You might also want to look at the Dynamic Update feature. Perhaps you can use that too.
I create one big QVD first (from all those CSV files) and shwoing data out of that QVD. Now, in this case, can I manipulate that QVD or can I only edit CSV files and change my model to skip creating QVD and directly showing data from (CSV) files?
