How to "store" data sets without ".csv" using operator "Loop File"+"read csv"?

blatoo

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?

blatoo

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?

MartinLiebig

Hi,

i would have gone the generate macro way as well. Seems like the fastest one for me.

~Martin