Discussion Board for collaboration related to QlikView App Development.
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
any help is really appreciated
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>
tried the one in Jonathan's link but did not help
any helpful links really appreciate
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);