Originally posted by: ThePilot

Hello,

I have a field in which I seem to be receiving a low value (Null).

This field is numeric and I have been looking at different functions to handle the null value but haven't been able to handle it

I've also searched the forum but didn't find a solution.

Thanks.

Originally posted by: Bragger

What exactly you want to do here? Is your map failing or you want to populate the NULL value in Output?

Originally posted by: PaulBrett

An IF(PRESENT()) function pair might be the way to go here, allowing you to populate the output with a default value, if the item is not present.

Please see the attached example.

Thank you.

Paul

Follow me on Twitter

Attachment(s)

NullNumber.zip   2 KB 1 version

Originally posted by: ThePilot

Hello,

When I try to build the map for Datapower, it is not failing.

The way I know its failing because when I head to Datapower and look at my audit log I'm receiving an "E02" status for the field. With the PRESENT function, I'm still getting  "E02".

Also, when I look at the response in the Debug Probe, I'm receiving a "One or more inputs was invalid".

I also tried putting a hardcoded 0 in the field just to try it out and it didn't work.

The only way I have seen the error go away is by making the field text(X) in the copybook, but this is clearly not a solution.

Please provide any suggestions.

Thanks for the answers.

Originally posted by: Bragger

If you are getting "One or more inputs was invalid" then clearly there is something wrong with input type tree. Can you share your input type tree so that we can check the properties?