Robin CK

asked on

# SSIS Derived column formula if a column is blank then pick data from some other column last 11 digits else same column

I have an MS Access formula which I want to use in SSIS package Derived column

GPN: iif(isnull([resouce GPN]),iif(Len([resource])>11,Right([Resource],11),""),[Resource GPN])

The formula reads, if "Resource GPN" column is blank then take last 11 digits of string from "Resource" column.

GPN: iif(isnull([resouce GPN]),iif(Len([resource])>

The formula reads, if "Resource GPN" column is blank then take last 11 digits of string from "Resource" column.

SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**