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

QlikviewRaj11 — Sat, 16 Nov 2024 18:12:48 GMT

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

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

QlikviewRaj11 — Wed, 19 Aug 2020 01:23:47 GMT

any one - really appreciate your time

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

Brett_Bleess — Thu, 03 Sep 2020 10:54:45 GMT

See duplicate post: https://community.qlik.com/t5/QlikView-App-Development/load-multiple-xlsx-files-in-a-folder-in-SharePoint/m-p/1736522#M452660

Regards,
Brett

topic Re: can someone hlep on figureing out how this is working... in QlikView

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

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

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