Options

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

  • Options
    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
Sign In or Register to comment.