Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

Generate Attribute based on a single value in example set

YumiYumi Member Posts: 1 Learner III
edited November 2018 in Help
I have a dataset like below
No.   Price1   Price2
0         A            0
1       200        300
2       120        800

I want to make it like this
No.   Price1   Price2      Code
1       200        300            A
2       120        800            A

I tried using generate attributes.. but the if else functions will check rows by rows. I have different datasets like this which are A, B, C... Can I use a macro to set the alphabet order?
Tagged:

Answers

  • JEdwardJEdward RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 578 Unicorn
    I'm sure I'm missing some obvious trap in the dataset, but assuming that the formats don't change and you have one dataset per letterValue, you could use Extract Macro to take the value of Price1 at the first position, then use Generate Attributes to add that macro value to the rest of the dataset. 
Sign In or Register to comment.