Data classification with 3 values through Turbo Grep

User222697
User222697 New Altair Community Member
edited November 5 in Community Q&A
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

Best Answer

Answers