The use of function DateTrans within Mapping, while source is NULL

[Former Member]

Hello,

I have the following problem. If the source field contains value NULL (it is just empty), Date Trans function return NullPointerException, thus stopping the entire mapping process.

Does anyone know a work around to this problem?

Thanks,

Dmitriy

[Former Member · Accepted solution]

Thank you, Udo.

But, this means that if the source value is not populated, the target would be populated with some value.

I was thinking that if the NULL is supplied as a source field, DateTrans should also return the null.

Isn't that true?

Dmitriy

[Former Member · Accepted solution]

Hi,

Try this...

IF the input equalsS space then space goes through else

input passed through the DateTrans function is passed through.

Thanks & Regards,

Renjith

[Former Member · Accepted solution]

Hello Renjith,

Thank you so much for your help. It worked. However, the question is why isnt there a check for a null value inside DateTrans function?

Dmitriy

[udo_martens]

Hi Dmitriy,

put an if before: if source field eqalsS '' then take 01012005, else take source field.

Regards,

Udo