How to "store" data sets without ".csv" using operator "Loop File"+"read csv"?
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?
0
Answers
But I am still want to know, are there any better ways to do that?
i would have gone the generate macro way as well. Seems like the fastest one for me.
~Martin
Dortmund, Germany