cancel
Showing results for 
Search instead for 
Did you mean: 

filter data based on the value of sorce field in mapping

Former Member
0 Kudos

Hi,

I have a scenario (IDOC to file) where i have to move data to target file, only when one of the source fields has particuler value. Otherwise skip the record, no need to write into output file.

Please let me know how to handle it in mapping, without BPM.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

You can use context object to filter based on value of source message.

Steps to be followed :

IR : Create context object in IR and assign to specific field of IDOC in message interface.

ID : In Receiver determination, while specifying the receiver, we can use this context object to determine the receiver and specify the required value. and select the option..skip if error.

Let me know if you need more information.

Regards,

Sreeni.

Former Member
0 Kudos

sreenivas, i tried to create context object and assign in message interface. But I am not able to see the context object in conditions of receiver determination.

We are looking under

conditions in receiver determination for the corresponding serivce ->condition editor->left operand-> we are selecting context object radio button and search for that context objec

its not appearing.

Former Member
0 Kudos

Karthik,

Ofcourse there is no need of BPM, You can use the IF without Else function in your mapping with using Equals function.

Example:

Field1 ---> Equals (Particualr Value) -


> IF -


> Then -


> pass it to Target field.

Since there is no Else option, therefore whenever condition will fail, nothing will be passed to the target field.

Regards,

Sarvesh

Former Member
0 Kudos

HI,

U can do it without BPM in mappping.

You do the validation on the root node of the target structure.

Check the value using the Equa string if its a required output then generate the target root node otherwise supress it. If the root node is supressed then the other child value will not be populated.

I think that is what u wanted?

Thnx

Chirag

Former Member
0 Kudos

Hi Chirag,

i used EQUALSS on source field while mapping target node to the IDOC node.

IF FIELD-X of source = 1000 THEN CREATEIF targetnode

Its working only when the condition is satisfied - FIELD-X of source = 1000

If FIELD-X of source is not equal to 1000 , its giving error. Pls let me know what should i do , if it has to just skip the record, without showing error.

Former Member
0 Kudos

HI,

What error it is giving to u.

I suggest rather then going for createif node take the output of node as true and false after comparision and give it to IF without elde node. It will work

Thnx

Chirag