Options

how to mapped Key and Value?

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
Hello ,
I have key in one column and values in other column , i want to mapped them.
e.g. I have Columns
Key       Values
A|B|C     X|Y|Z
i want outpuy
Mapped
A=X|B=Y|C=Z

Answers

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,517 RM Data Scientist
    Hi,
    sounds like a job for the Split operator :)

    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
    edited August 2020
    I want to do like below mentioned

    e.g. I have Columns Key and Value I want generate third column Mapped
    Key       Values     Mapped
    A|B|C     X|Y|Z      A=X|B=Y|C=Z
    Generate concatination works but not I wanted it gives output like
    A|B|C=X|Y|Z
Sign In or Register to comment.