Help me to derive new field based on my two fields?

[durgabhavani]

Hi All,

Can you please help me to compare two fields and derive new field (New Severity). Please find my sample data and expected output column.

Initial Severity	Latest Severity	New Severity (Expected Output)
High	Low	N/A
Low	Med	Med
Med	High	High
High	Low	N/A
Med	High	High
Low	High	High
Med	Low	N/A
High	Med	N/A
Low	Med	Med

[sunny_talwar]

That's great

[durgabhavani]

Hi Sunny,

Need you help here.

Please find my latest thread in community and advise me the solution.

Please help me to modify my existing script to derive new field.

Thanks,

Durga