The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

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

  • Telcontar120Telcontar120 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
  • ETMZETMZ Member Posts: 7 Learner II
    edited September 2022
    .
Sign In or Register to comment.