Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I have two folders which consists of multiple .csv files , I need to compare the both folders to load only the latest file among them.
For Eg:
FolderA:
ASDF_07092022.csv
FolderB:
ASDF_0909202222.csv
(The file name ends with date format DDMMYYYY).
My script needs to load the file from FolderB.
Could anyone suggest the optimized solution with script to achieve this story.
Thanks
Krishna
Hi Krishna.
Check the attached file for the Solution.
You just need to Change vFolderA and vFolderB for your Folder Connection Name.
Basically I read all files from both folders and get the name of them with the FileBaseName() Function
Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics
Hi Krishna.
Check the attached file for the Solution.
You just need to Change vFolderA and vFolderB for your Folder Connection Name.
Basically I read all files from both folders and get the name of them with the FileBaseName() Function
Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics
Thanks a lot Matheus_Zapparoli . I will check your solution and get back to you on the same. Once again appreciate your efforts.
Thanks
Krishna
Thanks Matheus_Zapparoli . The logic works fine with few minor changes.