cancel
Showing results for 
Search instead for 
Did you mean: 

Map with Null in SAP PI 7.0

Former Member
0 Kudos

Hi Experts

I am working on a RFC to File scenario, in the mapping one of the field on the target side needs to be mapped with Null (If there is no value coming from source)

How can I achive this, Is this needs to be done in Integration Directory or Repository

Thanks

PR

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

thanks

PR

former_member208856
Active Contributor
0 Kudos

Use Standard Functions

IF with ELSE

use condtion using Node FUnction EXISTS

IF --> Source --> Exists, Pass the value of Source.

Else, Pass the value of CONSTANT (SPACE).

Former Member
0 Kudos

Hi PR,

How can I achive this, Is this needs to be done in Integration Directory or Repository

As this has to be controlled in mapping, it will be done in repository.

I am working on a RFC to File scenario, in the mapping one of the field on the target side needs to be mapped with Null (If there is no value coming from source)

Try this mapping:

Constant[]----->

SourceField-->

equalS -


> ifThenElse

Constant[] -


>

SourceField -


>

-Supriya.

rodrigoalejandro_pertierr
Active Contributor
0 Kudos

HI

do this

field1->Exist>IF>(true)--->field1

>(false)->Constant("")

Former Member
0 Kudos

Hi PR,

> How can I achive this, Is this needs to be done in Integration Directory or Repository

In the mapping check the sender field, if that field not exists then pass null (Take constant function and write null) to target.

Regards

Ramesh

stefan_grube
Active Contributor
0 Kudos

> needs to be mapped with Null

What do you mean with this?