Hello Experts,
Happy Friday.
Here I have scenario, I have two different folders, one is FTP folder other one is a QV Source folder, Client will update some excel files at FTP folder. As a developer, I have to check the FTP folder, check for the latest file, if there is any. Then I need to copy it to the data source folder and rename it to the standard format. This is a completely manual process. Here I want to do automation. When even my qlikview does the reload, it needs to check boathfolders, based on the latest modified time, Excel file needs to copy to the QV\Datasource folder. How to do that? What is the best practice through QV macros.
Appreciate your help.
Thanks
San
