Options

How to split column values

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
edited July 2020 in Help
Hello,

I have column  'type' and "Attribute" that contain values

1       ?
2        FINANCIAL PRODUCT=REMITTANCE;Travel Card;Foreign Exchange
3        FINANCIAL PRODUCT=REMITTANCE;Travel Card
4         FINANCIAL PRODUCT=REMITTANCE;Travel Card |MESSAGE DIRECTION=I
5         ?
6         ?

how can split this column like
FInancial Product                                                               MessageDirection
REMITTANCE;Travel Card;Foreign Exchange                   I
w.r.t. type

Tagged:

Answers

  • Options
    Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn
    Try the "Split" operator and designate the "=" as the split character.
    You could also split the subsequent list by using the ";" character if you want.

    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
  • Options
    ETMZETMZ Member Posts: 7 Contributor I
    edited September 2022
    .
Sign In or Register to comment.