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
