laod better value between to columns (NVL)

[brf10043]

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

[rwunderlich · Accepted solution]

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

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com