Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to change the value of one field depending on the value of other field (column)

Highlighted

How to change the value of one field depending on the value of other field (column)

New Contributor

Hi,

Is it possible, with a CASE or IF statement, changing the value of one field depending on the value of another one? I'm doing an exercise in which the next condition is required:

If country_code='NULL', the field 'country' must be 'Other'

Thank you for your help. Regards.