Replace Null columns in ssis

Question

I want to add a column named CategoryCode which would take the first 3 letters of Category column + the first 3 letters of Subcategory column+ any number. The problem is that I have some values in CategoryCode column which I don't have to change. I just have to operate on values which is null. Can anyone help me with that? It would be of great help.

Hadi Hadi · Accepted Answer · 2022-01-05T20:54:14

You can simply add a Derived Column that replaces the input CategoryCode column using the following expression:

REPLACENULL([CategoryCode],LEFT([Category],3) + LEFT([SubCategory],3) + "123")

Replace Null columns in ssis

1 Answers