Question Re: Handling Null Values in Technology Q&A

Handling Null Values

itabhishek9 — Mon, 26 Sep 2016 10:23:25 GMT

Hi SDNites,

I am getting multiple <null> values in a field in the source structure where all other fields for that records have values.

My requirement is in case value is null (field not present in IDOC sent from SAP to PI), I would map it with default value in the target. I have tried to use mapwithdefault function but it is not recognising the null values. Also I tried to write the UDF but with in UDF when I use loop with condition input.length then this loop is not working as input.length is also not recognising the null values.

Can you please guide how can I achieve the same in SAP PI.

Regards,

Abhishek

Re: Handling Null Values

Former Member — Mon, 26 Sep 2016 10:44:44 GMT

Hi Abhishek,

The mapWithDefault will work.

Regards,

Praveen.

Re: Handling Null Values

apu_das2 — Mon, 26 Sep 2016 11:05:04 GMT

Hi Abhishek,

Add one more layer of validation and check-

First use exist() node function and then check whether the value is null or not null.

Thanks,

Apu

Re: Handling Null Values

vicky20691 — Mon, 26 Sep 2016 11:11:10 GMT

even more easy is use remove context , it will make all null become [] and then do splitbyvalue - each value

Re: Handling Null Values

Former Member — Mon, 26 Sep 2016 11:20:36 GMT

Hi Abhishek,

If the field context is set to its parent node then its not an issue. mapWithDefault will work.

If you make entire value of the field in one context that time it wont work.

Solution to handle the above situation:

Like in the above example, You can solve it source Node- mapWithDefault-removeContext-target Node

Hope this will be helpful.

Thanks

Sagarika

Re: Handling Null Values

itabhishek9 — Mon, 26 Sep 2016 12:27:11 GMT

Thanks everybody for your response. It has been resolved now and have used mapwithdefaults function.