expression

Question

I have the txt file with several columns (Code, Earing, OverTime, Vacation). I need to set the fit value for column Earning =10 if the the Code ="A" .

Something like this but I am not sure?

(TRIM([Code])) == "A" ? [Earing] ==20 : ""

Thanks

Answer 1

Hi @Vicki ,

You may use below code:

Code == "A" ? "10" : [ Earing]  

or

Code == "A" ? "10" : ""  

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

It worked, thank you

Answer 3

Hi @Vicki ,

Please try the following expression in the SSIS Derived Column transformation:

TRIM([Code]) == "A" ? "10" : ""