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 :)

Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,503 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
  • 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.