Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

pick the most recent file from sharepoint folder

Hi All,

can anyone please provide the link if it is already exists.. i have .csv files in a sharepoint folder

i need to pick the most recent .csv file and load it ..

Test:
Load * From [htts://address/Metrics_2019_09_18.csv] (txt, code page is 28591,embedded labels, delimiter is ',',msq, headerlines 10, no eof);

this is working fine...i need to get the most recent file based on the file name which includes the date

like Metrics_2019_09_18.csv

Metrics_2019_09_17.csv

etc

any help is really appreciated

 

 

 

 

 

 

 

 

 

 

4 Replies
Highlighted
Creator II
Creator II

anyone please..

Highlighted
Creator II
Creator II

I tried to use the one mentioned by Jonathan - but it is not working

<a href="https://community.qlik.com/t5/forums/replypage/board-id/qlikview-app-development/message-id/446080" target="_blank">https://community.qlik.com/t5/forums/replypage/board-id/qlikview-app-development/message-id/446080</a>

 

anyone please

Highlighted
Creator II
Creator II

tried the one in Jonathan's link but did not help

any helpful links really appreciate

 

Highlighted
Specialist II
Specialist II

If you want to identify the latest file based on the filename just store the required dates in a variable and use it in load 

Let Variable1 =  date(today(),'YYYY_MM_DD') ; 

Test:
Load * From [htts://address/Metrics_$(Variable1).csv] (txt, code page is 28591,embedded labels, delimiter is ',',msq, headerlines 10, no eof);