RapidMiner 9.8 Beta is now available

Be one of the first to get your hands on the new features. More details and downloads here:

GET RAPIDMINER 9.8 BETA

How to split column values

sgnarkhede2016sgnarkhede2016 Member Posts: 101 Contributor II
edited July 23 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 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,530   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
Sign In or Register to comment.