Options

Header Concatenation

floyd1233floyd1233 Member Posts: 2 Contributor I
edited December 2018 in Help

Hi, Input file has 3 Headers (3 Rows). How can they be merged as 1. Sample file attached

RM.png 11.4K

Answers

  • Options
    FBTFBT Member Posts: 106 Unicorn

    Merged cells, as in the first two rows in your sample screenshot on the left, are a bit problematic, when you intend to manipulate the data. Depending on the amount and exact structure of your data, you could consider to import your file wihtout the two rows that have merged cells. You can than rename the attributes with the rename attributes operator and give them the desired name. 

  • Options
    Edin_KlapicEdin_Klapic Moderator, Employee, RMResearcher, Member Posts: 299 RM Data Scientist

    Hi floyd1233,

     

    Please note that RapidMiner cannot handle two Attributes (i.e. columns) with the same name or role.

    This needs to be handled upfront.

     

    Best,

    Edin

     

Sign In or Register to comment.