Data classification with 3 values through Turbo Grep

User222697
User222697 New Altair Community Member
edited November 2024 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

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.