Data classification with 3 values through Turbo Grep
User222697
New Altair Community Member
Hi,
i want generate a new colum which computes three possible values (A,D or H)
A = Score2>Score1
D = Score2==Score1
H = Score1>Score2
Score1 Score2
2 4
2 2
5 1
Result
A
D
H
Through the following syntax i can generate two values, but how can i generate the three possible options (A,D,H)?
if(Score1>Score2, "H", "A or D")
Thanks and sorry my ignorance
i want generate a new colum which computes three possible values (A,D or H)
A = Score2>Score1
D = Score2==Score1
H = Score1>Score2
Score1 Score2
2 4
2 2
5 1
Result
A
D
H
Through the following syntax i can generate two values, but how can i generate the three possible options (A,D,H)?
if(Score1>Score2, "H", "A or D")
Thanks and sorry my ignorance
Tagged:
0
Best Answer
-
2
Answers
-
2