ID in the excel file

KathiKathi Member Posts: 11 Contributor I
edited October 2019 in Help
Hi everyone,

I'm doing a calculation of the cosine similarity and added the 'write excel' operator at the end of my process.
First I import the data and define one row of my excel file as the ID (in the Edit Data part, the blue row in picture 1).
RapidMiner ist writing my ID in the excel file but on the right side of my table. Can I get RapidMiner to write the ID at the left side (first coloumn of my excel file)?

Thanks and best regards,

Best Answer

  • Options
    varunm1varunm1 Moderator, Member Posts: 1,207 Unicorn
    edited October 2019 Solution Accepted
    Hello @kathi

    You can use "reorder attributes" operator. If you cannot see ID in attribute list, make it a regular attribute using set role and then attach it to reorder attributes and write to excel.

    I attached modified .rmp, you can make changes in the set role and reorder attribute.

    Hope this helps. Please inform if you need more information

    Be Safe. Follow precautions and Maintain Social Distancing


  • Options
    KathiKathi Member Posts: 11 Contributor I
    Hi Varun,

    it's working. Thank you for your help!

Sign In or Register to comment.