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
