Generate Attribute based on a single value in example set
Yumi
New Altair Community Member
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?
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:
0
Answers
-
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.0