Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,365 questions
Multiple variables in wildcard source in Data Flows ADF
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 77%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Degenocrat
27
Reputation points
Hello,
I have partitioned files in my data lake by year and month. I would like to read multiple 'year' folders as a single source in Azure Data Factory Data Flow using wildcard.
Currently I managed to read just a single year in my wildcard and added another source for a different year. I then union the two datasets. See pictures below.
The years and months are parameters in the screenshots, but when exploring particular years I just add them as strings directly in the wildcard path. They represent a folder under which the childs are months with their respective datasets. So far I have tried passing (2022|2021) in various formats, but this results in an error.
How do I pass multiple specific variables in a wildcard path?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,622 Reputation points Microsoft Employee2022-12-19T23:28:03.653+00:00 Hello @Degenocrat ,
Thanks for the question and using MS Q&A platform.
To better assist on your query, could you please share the complete wildcard expression along with the complete error message you are seeing?
Thank you
-
KranthiPakala-MSFT 46,622 Reputation points Microsoft Employee
2022-12-23T00:36:59.843+00:00 Hello @Degenocrat ,
Checking to see if you have got a chance to see my previous comment, if so, could you please share the complete wildcard expression using are trying along with the complete error message you are seeing?
Thank you
Sign in to comment
Sign in to answer