File path in Dataset

Question

I have a folder inside the blob storage. Inside the folder I have two different files consider it as

1. file_name.csv
2. file_name.xlsx
   Each time the the fine_name will change. So instead of changing the file name manually in file path each time in data set.
   Can I add an expression in file path saying select the file with .xlsx extension.

Note: In the below image in File Path container / Directory will always same each time I use to change the file name

Answer 1

Hi @Ram ,

Thanks for posting question in Microsoft Q&A platform.

As I understand your ask, you want to copy only .xlsx files to be copied to Sink using Data Flow activity.
Sorry to inform you in Data Flow xlsx is currently not supported. Please consider converting files to csv format and then follow below mentioned steps. We consider that the different files have same schema.

In the Source Settings, select Inline in Source Type:

Next, in Source Options tab, give Wildcard Path as shown below:

]

Hope this will help. Please let us know if any further queries.

---

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification

Answer 2

Hi Ram,

Thanks for reaching out to Microsoft Q&A.

Yes you can create an expression to pick your file names dynamically.

Each time the the fine_name will change. So instead of changing the file name manually in file path each time in data set.
Can I add an expression in file path saying select the file with .xlsx extension.

Note: In the below image in File Path container / Directory will always same each time I use to change the file name

In the above case it will select all the .xlsx files only, from the container directory you will provide.

Please Upvote and Accept as answer if the reply was helpful.

Answer 3

Hi @Ram

I just tried copying only .xlsx files from my ADLS container named demo. I was able to copy it as .csv

My container has different set of files as shown

My data flow source settings:

In the sink, i have saved the .xlsx as .csv file in my output folder and the pipeline ran fine and copied xlsx as csv

Here i have decided to use pattern for file names.

Hope it helps.