Hi @Brianna C
Thank you for reaching out to us with your query.
As you mentioned that every new file of yours will be in
TableA_YYYYMMDD format, you can use wildcard path in the copy activity source to get the latest files.
Here, I have taken my source as ADLS gen2, but the process is same.
These are my source csv files:
Here I used Set variable activity to store the current date in
YYYYMMDD format in a string variable.
Now use copy activity to retrieve the latest files from storage account based on date.
Here, my files end with
.csv and thats why I have given
* at the end of the expression. So, you can keep it if there is any file extension for your files. Now, use this in giving wildcard file path like below.
Recursively option, if there is any requirement of copying files recursively from sub folders.
In the sink file, give your target folder path.
Debug the pipeline, once it successful you will get the latest file as below:
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click
Accept Answer and
Yes for was this answer helpful. And, if you have any further query do let us know.