Fetching data from Share point(FTP)

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to read the data from a share point folder where the users can directly upload the data and QV can fetch it and create Qvds based on the same data. Say, I have a folder named 'Test' which has excel files Employee-1,Employee-2,Employee-3.

So I created variables for both the folder path and file name.

vfile='Employee-'

and while fetching this data I put ->

from

$(vpath)$(vfile)*.xlsx

But this does not reload and it gives me an error, whereas if I put the file name one by one it reloads...

eg->

from

$(vpath)Employee-1.xlsx

Any suggestions or experiences?

Re: Fetching data from Share point(FTP)

avinashelite — Thu, 09 Jun 2016 12:00:05 GMT

As per my knowledge FTP doesn't support wild cards

try with the for each loop statement with filelist function

topic Re: Fetching data from Share point(FTP) in QlikView

Fetching data from Share point(FTP)

Re: Fetching data from Share point(FTP)