filter out certain pattern date files

%3CLINGO-SUB%20id%3D%22lingo-sub-2596375%22%20slang%3D%22en-US%22%3Efilter%20out%20certain%20pattern%20date%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2596375%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3BI%20want%20to%20filter%20out%20certain%20pattern%20date%20files%20in%20a%20particular%20folder%20and%20copy%20those%20files%20into%20data%20lake%20storage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efilenames%20in%20source%20folder%3A%3C%2FP%3E%3CP%3EEDL_infy_20201201_wex.csv%3C%2FP%3E%3CP%3EEDL_infy_20201202_wex.csv%3C%2FP%3E%3CP%3EEDL_infy_20201203_wex.csv%3C%2FP%3E%3CP%3EEDL_infy_20201204_wex.csv%3C%2FP%3E%3CP%3EEDL_infy_20201205_wex.csv%3C%2FP%3E%3CP%3EEDL_infy_20201206_wex.csv%3C%2FP%3E%3CP%3EEDL_infy_20201207_wex.csv%3C%2FP%3E%3CP%3EEDL_infy_20201208_wex.csv%3C%2FP%3E%3CP%3EEDL_infy_20201209_wex.csv%3C%2FP%3E%3CP%3EEDL_infy_20201210_wex.csv%3C%2FP%3E%3CP%3EEDL_infy_20201211_wex.csv%3C%2FP%3E%3CP%3EEDL_infy_20201212_wex.csv%3C%2FP%3E%3CP%3EEDL_infy_20201213_wex.csv%3C%2FP%3E%3CP%3EEDL_infy_20201214_wex.csv%3C%2FP%3E%3CP%3EEDL_infy_20201215_wex.csv%3C%2FP%3E%3CP%3EEDL_infy_20201216_wex.csv%20and%20so%20on..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Erequirement%20is%20copy%20date%20pattern%20files%20from%2020201201%20to%2020201210%20into%20target%20folder.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20used%20getmetadata%20activity%20and%20lookup%20and%20foreach%20activity%20i%20tried%20but%20not%20full%20fill%20the%20solution..can%20you%20please%20help%20me%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ESubba%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2596375%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eazure%20data%20factory%20v2%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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