Options

Is there a dynamic way to split a document ?

nic__onic__o Member Posts: 7 Newbie
edited December 2019 in Help
Hi, I'm currently spliting an excel sheet with the operator 'Split Data' , I split the document in 3 because he has 3 column. 
I would like that regardless the document I have in input (always an Excel file), this one is split in fonction of his number of column. And so i don'd have to create manually the number of output that i want.

Is this possible ? 

I hope to have be clear.

Thank's :)
Tagged:

Answers

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,509 RM Data Scientist
    Hi @nic__o ,
    so you want one example set per attribute? I guess Loop attribute + Select Attributes should do the trick in some way..

    BR,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn
    Why doesn't Read Excel not handle this automatically for you?  You should be able to put it inside Loop Files and provide the file input and then it will parse the data automatically based on the columns that exist in Excel.
    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
Sign In or Register to comment.