CODEWITHSUNDEEP
ssisnullderived
Elaine Casey
Elaine Casey

Reputation: 29

SSIS Derived Column IS NOT NULL with Or expression

I need assistance writing an Derived Column expression that meets this criteria.

IF ([Name of Job] is "Accenture Leadership" OR "Senior Executive") AND [Pay scale Group] IS NOT NULL THEN [Pay scale Group] ELSE [Name of Job].

Thanks,

Upvotes: 2

Views: 24691

Answers (1)

Mike Henderson
Mike Henderson

Reputation: 1317

Try this:([Name of Job] == "Accenture Leadership" ||[Name of Job] == "Senior Executive") && ISNULL([Pay scale Group]) == FALSE ? [Pay scale Group] : [Name of Job]

reference

Upvotes: 7

Related Questions