can someone hlep on figureing out how this is working...

[QlikviewRaj11]

Hi,  I came across one link where the guy loads multiple excel files into qv from share point

I am trying to replicate the samething - I used the https address in vDirectory variable - don't get his - error FileText not found

Set vDirectory =[https://Sharepoint/Directory];

Filenames:

LOAD left(FileText,29) & '.xlsx' as FileName,

     mid(FileText, 20,10) as CreateDate,

     Trim(Replace(left(FileText,29) & '.xlsx',' ','20%')) as Webfile,

     ModifiedDate

FROM $(vDirectory)

(html, codepage is 1252, embedded labels, table is @6   );

when I go to webfiles - select internet files and use the https:// address and select html - this is how it looks like

how does this works in the above - that was from someone in the forum - once I get the list of files I can pass each file name to the for loop - any help

[QlikviewRaj11]

any one - really appreciate your time

[Brett_Bleess]

See duplicate post: https://community.qlik.com/t5/QlikView-App-Development/load-multiple-xlsx-files-in-a-folder-in-Share...

Regards,
Brett