Options
Generate Attribute based on a single value in example set
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