How to add file name as a column in Data set

[KaterinaSimerdova]

Hello,

can you please advise how to add file name as a column of the data input?

I only found option for Desktop version of Alteryx..

Thank you!

[alexnajm]

Currently not an option that I am aware of - you'll need to create it manually with a Formula tool

[KaterinaSimerdova]

Thank you, Alex, for your reply!

 What do you mean to create it manually using formula? Thank you.

[alexnajm]

Create a column in a Formula tool and hardcode it as the file name that you have - "File name.xlsx" or whatever you want to type

[KaterinaSimerdova]

I think I understand.. but my problem is that it is not just one excel.

I've loaded a folder with excels and I'm adding every month new excel to it. Name is YYYY MM_NAME.csv.

And I would need name of the csv files in the data set (because of the date..)

[alexnajm]

I'm confused - Are you using Designer Cloud? That's where this question is posted

[alexnajm]

At this stage, you'll need to show us more about your current state for us to help - I am just shooting in the dark based on the information provided

[KaterinaSimerdova]

Yes, I'm using Designer Cloud.. I will try to better explain..

1. I connect to data using Azure Data Lake Storage
2. I create Data set connecting to a folder that contain multiple csv files.

Those csv files are named YYYY MM_FILE NAME.csv.

I would need to add the file name in the date set, so that I'm able to get the period,

the result should be following:

file name (to extract period from the name	COLUMN1	COLUMN2	COLUMN3
01/01/2025	xxx	1000	MrS
01/01/2025	yyy	500	MrS
01/02/2025	yyy	200	MrsT
01/02/2025	aaa	1000	MrS

[alexnajm · Accepted solution]

Unless the input data tool in cloud has the ability to output file name as a field for Azure Data Lake specifically, I don't think this is possible - I can't test as we don't have it but I tried with a couple different connections and I don't see the ability to have the original source as a column

You can submit a ticket with Alteryx support to confirm

[KaterinaSimerdova]

Thank you very much for your time and replies, Alex!