topic Re: loading in QlikView

loading

Anonymous — Mon, 05 May 2014 11:56:32 GMT

Hi Guys ,

I have a qvw where i need to load multiple csv files from a path. Everytime i need to hit all the csv files from the path.

I want to apply a incremantal logic in such a way so that only new files will be loaded into the report.(as per attachment)

Could you please help me on this

Re: loading

fkeuroglian — Mon, 05 May 2014 14:02:39 GMT

Hi, see this document

Good Luck

Fernando

Re: loading

rajeshvaswani77 — Mon, 05 May 2014 14:23:12 GMT

Hi Rajashmita,

You have to read a file and once read, move it to an archive folder.

Hope this helps.

thanks,

Rajesh Vaswani

Re: loading

sudeepkm — Mon, 05 May 2014 14:31:37 GMT

in your case you do not have a date field in your table based on which you could have load data from new files.

I've created an example using which you can check the file creation time and the QVW will load data from only those files whose file time is > than the max file time available in QVD. Please take a look at the attachment.

You can also refer to Reloadtime() if you do not want to compare based on file creation/modified time while doing incremental load.