Dear Experts ,

[former_member221434]

whenever  i m using the exists function , if I don't give any value for the particular source field at that time the default constant value is not passing from source to target rather its showing NULL value.

[Harish · Accepted solution]

Hi Pradeep,

As per your input data name is present in input and it is passed to output. If you want the blank value (Null) should not passed to output then modify the mapping as below.

Name --> Map with default (blank) --> equals (blank) --> Not

then map Name in then condition

else map default value in else condition

regards,

Harish

[former_member221434 · Accepted solution]

Dear Harish ,

Can u please give me a example set (if possible with screenshot) , whatever you are saying as I am still confused and the issue is not resolved.

regards,

Pradeep

[Former Member · Accepted solution]

Hello Pradeep ,

Use this :

Hope this helps!!!

Thanks

Gaurav

[former_member221434 · Accepted solution]

Dear Gaurav and  Harish

                      Thanks a Lot for your quick response and help. Its working now.

Regards

Pradeep

[Former Member · Accepted solution]

Hello Pradeep ,

Please close this thread from your end.

Thanks