Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
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.
Find more posts tagged with
AI Studio
Accepted answers
All comments
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
sample.rmp
ZZMS.SG.csv
TLGF.BK.csv
ICLD.csv
SHGY.csv
SLF-PG.TO.csv
PVL.csv
NXOPF.csv
300256.SZ.csv
MTR.F.csv
DBV.PA.csv
GRTD.csv
NBCC.NS.csv
6BC.F.csv
300266.SZ.csv
MFC-PF.TO.csv
002600.SZ.csv
NP7.F.csv
EISA.SN.csv
6k_1.xlsx
MOHF.F.csv
SRCRF.csv
HVTA.L.csv
HMO.F.csv
MIDVAL.BO.csv
BRLAF.csv
300210.SZ.csv
DWNI.DE.csv
6D81.F.csv
F2I.F.csv
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
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups