topic Re: Checking uploaded files in QlikView

Checking uploaded files

qlikviewwizard — Mon, 06 Apr 2015 06:00:28 GMT

Suppose there are 5 excel file uploaded on sharepoint.

file1

file2,

file3,

file4,

file5

I want to check if all the files are uploaded or not through Qlikview script?

Thanks in advance.

Re: Checking uploaded files

petter — Mon, 06 Apr 2015 06:26:08 GMT

If you only want to check if they are uploaded as you say you can read the SharePoint-list as an RSS-feed and you select web files in your wizard and tell the wizard that it is XML-format. Then you should be able to check the records you get back to see if the files are there.

Re: Checking uploaded files

tresB — Mon, 06 Apr 2015 06:38:22 GMT

While loading the files, create an extra field like:

Load

FileName() as File

From <>;

If the files are of similar structure, they are probably concatenated by you, if so you get all the file names in the field File, now you can do your analysis/check.

Re: Checking uploaded files

prieper — Mon, 06 Apr 2015 06:56:29 GMT

You will receive an error, if one file is not available.

Else - in case files are there, but not updated - you may check on timestamp of the files (should be newer than ...)

Or you may check on number of records within the file ....

Peter

Re: Checking uploaded files

qlikviewwizard — Mon, 06 Apr 2015 07:04:36 GMT

Could you please provide the script for better understanding.