'How to give dynamic expression path for file location (Wildcard file paths) in Azure data factory?

I am getting every data single excel file in my data lake. My container name is 'odoo' in the data lake. Excel files get stored in the folder called 'odoo' and below is the name of the file

report_2022-01-20.xlsx

I am using dataflow and I wanted to take everyday file using a wildcard path. Below is the dynamic expression I am trying to give but no success

/odoo/@concat('report_', string(formatDateTime(utcNow(), 'yyyy-MM-dd')), '.xlsx')

Can anyone advise me how to write the correct expression? I am a newbie to the adf.

azureazure-data-factoryazure-data-lakeazure-data-flow


Solution 1:[1]

Can you try: @concat('/odoo/report_', formatDateTime(utcNow(), 'yyyy-MM-dd'), '.xlsx')

The string() might be causing the issue

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions