laod better value between to columns (NVL)

brf10043 — Sat, 16 Nov 2024 18:41:20 GMT

Team when loading data from a .qvd I have two similar columns. (CS_Discovered_OS & CS_CHM_OPERATING_SYSTEM)

How do I create a new column called Preferred_OS based on logic detailed below?

If CS_Discovered_OS is not null take the CS_Discovered_OS value

If CS_Discovered_OS is null take the CS_CHM_OPERATING_SYSTEM value

If CS_Discovered_OS & CS_CHM_OPERATING_SYSTEM are both null, return a Null

Re: laod better value between to columns (NVL)

rwunderlich — Thu, 07 May 2020 04:12:47 GMT

if(len(CS_Discovered_OS) > 0, CS_Discovered_OS
,if(len(CS_CHM_OPERATING_SYSTEM) > 0, CS_CHM_OPERATING_SYSTEM
, null()
)) as Preferred_OS