Fetching data from Share point(FTP)

[#1]

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?

[avinashelite]

As per my knowledge FTP doesn't support wild cards

try with the for each loop statement with filelist function