filter out certain pattern date files

Occasional Visitor

Hi,

   I want to filter out certain pattern date files in a particular folder and copy those files into data lake storage.

 

filenames in source folder:

EDL_infy_20201201_wex.csv

EDL_infy_20201202_wex.csv

EDL_infy_20201203_wex.csv

EDL_infy_20201204_wex.csv

EDL_infy_20201205_wex.csv

EDL_infy_20201206_wex.csv

EDL_infy_20201207_wex.csv

EDL_infy_20201208_wex.csv

EDL_infy_20201209_wex.csv

EDL_infy_20201210_wex.csv

EDL_infy_20201211_wex.csv

EDL_infy_20201212_wex.csv

EDL_infy_20201213_wex.csv

EDL_infy_20201214_wex.csv

EDL_infy_20201215_wex.csv

EDL_infy_20201216_wex.csv and so on..

 

requirement is copy date pattern files from 20201201 to 20201210 into target folder. 

 

I used getmetadata activity and lookup and foreach activity i tried but not full fill the solution..can you please help me out.

 

Thanks,

Subba

   

0 Replies