combine some excel files

sara20sara20 MemberPosts:110Unicorn
edited July 2020 inHelp
Hello

I need to read some excel rows in different excel files and make one new excel file with those rows. Now how is it possible with RM?
Tagged:

Answers

  • jacobcybulskijacobcybulski Member, University ProfessorPosts:391Unicorn
    You can use several Read Excel operators to get your spreadsheets in, then Append, and Write Excel.
    sara20
  • MarcoBarradasMarcoBarradas Administrator, Employee, RapidMiner Certified Analyst, MemberPosts:271Unicorn
    Hi@sara20you could use a Loop Files operator with a Read Excel inside and and an Append and a Write Excel angt the end.
    You could copy this basic setup
    Inside the Loop Files you could do any type of data cleansing and filtering that you could need.

    < ?xml version = " 1.0 " encoding = " utf - 8 " ?> <过程版本sion="9.7.001">


    sara20
  • sara20sara20 MemberPosts:110Unicorn
    edited July 2020
    jacobcybulski,
    MarcoBarradas,

    Hello

    Thank you very much for your answers. I will try them.:)

    Best regards
    Sara
Sign InorRegisterto comment.