Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
durgabhavani
Creator III
Creator III

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

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 SeverityLatest SeverityNew Severity (Expected Output)
HighLowN/A
LowMedMed
MedHighHigh
HighLowN/A
MedHighHigh
LowHighHigh
MedLowN/A
HighMedN/A
LowMed

Med

21 Replies
sunny_talwar

That's great

durgabhavani
Creator III
Creator III
Author

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