Mapping error with respect to nodes

[Former Member]

hi,

We have 5 fields in node1 with occurance(0:10) . If all the 5 fields exists then create the target node.

We used 5 fields>exists>Createif-->target node

Now we are facing an issue like. Node1 is repeated thirce on source side. Where in the third segment is not having all 5 required values, But as the same fields exists in above nodes the mapping is returning true and creating the target node.

We dont want this to happen any solution please.

TIA

[Former Member]

Prabhas,

I feel the problem can be solved if the we create some blank value for the fields which does not occur under one occurence of the node. Try doing below and I feel the problem might get resolved.

Use IF-ELSE function along with the existence of fields to create a NULL value for the occurences in which fields are absent for e.g IF Field1 Exists then pass Field1 ELSE pass constant "NULL" and from the output of this IF-ELSE check if it is NOT EQUALs to NULL and then as Raj suggested apply AND operations to the output of these EQUALS for all fields containing the same logic similar to Field1 and at last use CREATEIF.

Also, no need to change the context of fields let them be at their original context.

Hope this would resolve the issue.

Regards,

Amit

Edited by: Amit valecha on Oct 17, 2011 12:10 PM

[Former Member]

Prabhas

Use 5 fields(With lower context)>exists>Createif>Remove Context>target node

Regards

Raj

[Former Member]

hi,

Tried but still same output.

[Former Member]

Prabhas

You must have used each of the 5 fields>exists>Createif-->target node

Such as

[Least Context] field1-->exists-->And---\
[Least Context] field2-->exists--/       And---\
[Least Context] field3-->exists----------/     And---\
[Least Context] field4-->exists---------------/      And---Createif-->Remove Context---->target node 
[Least Context] field5-->exists---------------------/      
 

Regards

Raj

[Former Member]

Can you be clear on least context?

Right click on the field and change context?

[Former Member]

Can you be clear on least context?

Right click on the field and change context? 
 

Right click on the field and change context to the fields level it self... the lowest in the list. (Which is the byDefault option)

[Former Member]

hi

Tried but still no use that target segment is created

[Former Member]

Please let me know, how you are testing it.

[Former Member]

Right click on 5 fields selected the NODE1 context.. And remove context after createif

[Former Member]

I mean to say about the payload.. What payload you are using to test it.

I guess it should be like this::::

Node1 (A)

Field1

Field2

Field3

Field4

Field5

Node1 (B)

Field1

Field2

Field3

Field4

Field5

Node1 (C)

Field1

Field2

Field3

Field5

The mapping shown should work. Please recheck where you are missing.

[Former Member]

Let me rephrase RAJ.

Paylod is like this

NODE1(A)

field1

field2

field3

field4

field5

NODE1(B)

field1

field2

field3

Field 4 and 5 are not populated here.

So on target side. first node is created sucesfully as all fields exist.. But it's second occurance shouldn't be there. But it's creating the second node.

[Former Member]

Try to implement the logic which I have suggested in my previous post in this forum ..... I had kept this situation in mind and I hope it would solve the problem.

Regards,

Amit