Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Compare filelist from ftp location with files in multiple folders on pc and pick them by folder

Hello,

On my ftp location, I have folders: Alpha, Beta, Chroma, Delta which in turn have folders, Alpha1, Alpha2, Alpha3; Beta1, Beta2, Beta3; Chroma1, Chroma2, Chroma3; Delta1, Delta2, Delta3 respectively. Each of these folders have .csv files with names, Data_date.csv (ex. Data_01_01_2018.csv). The file names are common along folders. I have some of these files on my in folders by the same names as FTP location. I need to compare both, get a list of files that are not present and pick those files to pc storage. Can someone suggest me how to do this?

In future, I also need to have it so that there are no files on PC but only the list of files that were before and whatever filename isn't on the filelist, has to get picked.

Anyone here to help?

 

Thanks in advance.

Labels (3)
10 Replies
Anonymous
Not applicable
Author

@fdenis, got it. Thank you. Figured out a different way with loops. 0683p000009MACn.png

Thanks a lot for help. 0683p000009MACn.png