derived col trans support

Question

Hi Experts,

I am facing issue with derived col transformation.

In the pic attached below are the formula
People Aged Above 18: (DT_I4)DATEDIFF("Minute",(DT_DATE)Patient_In,(DT_DATE)Patient_Out)
Appointment > 500 minutes are defaulted to 60 minutes: (DT_STR,50,1252)[People Aged Above 18].Mins > "500" ? "60" : (DT_STR,50,1252)[People Aged Above 18].Mins

I am taking the datediff and checking if diff mins are > 500 then covert into 60 mins else keep the difference. but some of the data is also converting. eg are attached in pic

Answer 1

This is because you are comparing data as strings instead of integers. You can simply omit the type casts and specify integer literals if the data type is DT_I4 as the first expression suggests:

[People Aged Above 18].Mins > 500 ? 60 : [People Aged Above 18].Mins

If you want a string result, add a type cast of the result back to string:

(DT_STR,50,1252))([People Aged Above 18].Mins > 500 ? 60 : [People Aged Above 18].Mins)