Is there a dynamic way to split a document ?

nic__onic__o MemberPosts:7Newbie
edited December 2019 inHelp
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

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University ProfessorPosts:3,404RM Data Scientist
    所以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, MemberPosts:1,635Unicorn
    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 InorRegisterto comment.