How to "store" data sets without ".csv" using operator "Loop File"+"read csv"?
blatoo
New Altair Community Member
Hi all,
I have a bunch of csv files. I want to read them into my repository.
So I use "Loop File" and "Read.CSV" read all the data in the folder and "store" them with: repository entry: .../%{file_name}.
It works, but I have a problem, I don't want the name of the data sets in my repository with ".csv" extension. How can I do it?
I have a bunch of csv files. I want to read them into my repository.
So I use "Loop File" and "Read.CSV" read all the data in the folder and "store" them with: repository entry: .../%{file_name}.
It works, but I have a problem, I don't want the name of the data sets in my repository with ".csv" extension. How can I do it?
Tagged:
0
Answers
-
I found the solution at last. I used the "generate macro" to control the file_name string.
But I am still want to know, are there any better ways to do that?0 -
Hi,
i would have gone the generate macro way as well. Seems like the fastest one for me.
~Martin0