Options

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

blatooblatoo Member Posts: 32 Contributor II
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?

Answers

  • Options
    blatooblatoo Member Posts: 32 Contributor II
    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?
  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,517 RM Data Scientist
    Hi,

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

    ~Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.