Forum Discussion
harry619
Sep 14, 2021Copper Contributor
Wildcard path in ADF Dataflow
I have a file that comes into a folder daily. The name of the file has the current date and I have to use a wildcard path to use that file has the source for the dataflow. I'm not sure what the wildc...
Mumu_tech
Oct 08, 2021Copper Contributor
Wildcard is used in such cases where you want to transform multiple files of same type. For example, Consider in your source folder you have multiple files ( for example abc_2021/08/08.txt, abc_ 2021/08/09.txt,def_2021/08/19..etc..,) and you want to import only files that starts with abc then you can give the wildcard file name as abc*.txt so it will fetch all the files which starts with abc
In your case you are going to copy one file ( Current data file) alone daily, So you can configure using "schedule" window. Kindly refer https://www.mssqltips.com/sqlservertip/6365/incremental-file-load-using-azure-data-factory/ for detailed steps
In your case you are going to copy one file ( Current data file) alone daily, So you can configure using "schedule" window. Kindly refer https://www.mssqltips.com/sqlservertip/6365/incremental-file-load-using-azure-data-factory/ for detailed steps