Checking uploaded files

[qlikviewwizard]

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.

[petter · Accepted solution]

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.

[tresesco]

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.

[prieper]

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

[qlikviewwizard]

Could you please provide the script for better understanding.