How to mapped below string

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
Hello,
I have a below string 
PROD_CODE|MESSAGEDIRECTION|COUNTERPARTY_RISK=Corporate REMITTANCE|I|HIGH

I want output like
PROD_CODE=Corporate REMITTANCE|MESSAGEDIRECTION=I|COUNTERPARTY_RISK=HIGH

Answers

  • Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn
    One approach would be to use the Split operator first to separate all these into separate attributes (based on the | and = symbol) and then use Generate Attributes (Concatenate function) to reconstruct using only the elements and the order you want.

    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
    Pavithra_Rao
Sign In or Register to comment.