how to add file name as an attribute in your dataset?

hellomoto

I am using loop files and append superset operators to stitch time series historical stock data from thousands of csv files together, each stock has a different csv file, and I am able to successfully do that but I also need to add stock name or file name as an attribute to every row which will act as an ID for every stock. I have been stuck at it for days. Any help would be greatful.

MartinLiebig

Hi,

the loop files operator has an option 'enable macros'. Once checked you can use the file_name macro in generate attributes to do this.

Best,

Martin

hellomoto

I tried and it's showing an error, I have attached my process with sample data here, can you edit the process and send it back to me, I hope i am not asking for too much.

Thanks

Deshmukh

MartinLiebig

Hi @hellomoto ,

what is the error shown?

~Martin

hellomoto

hi @mcshmitz, 

I guess I was doing it the wrong way, it seems to have worked, thank you so much. 

Deshmukh