cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping issue: Based on nodes/Context

Former Member
0 Kudos

Hi Experts...

Can someone help me with the below mapping logic?

if A_NUM = B_NUM; pass NAME

Here is the source structure:

ROOT
            NODE1
                        NODE2
                               A_NUM
 
            NODE3
                        B_NUM
                        NAME
 
            NODE4
                        B_NUM
                        NAME

Thanks in advance!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

HI,

If a_num(change its context to its parent(node1)) EqualsS B_num then map the name to target....

drag and drop ifwith out else.....and take a equalsS from text functions and do as said above...

thanks,

Mahdu

Former Member
0 Kudos

Thanks Ragu and Madhu- It did not work!

Updating with occurrence and correct Node heirarchy

ROOT                                (1-1)
 
            NODE1                           (0-unb)
                        NODE2               (0-unb)
                                    A_NUM   (0-1)
            NODE3                           (0-unb)
		NODE4                       (1-1)
                        	B_NUM       (0-1)
                        	NAME         (0-1)
            NODE5                           (0-unb)
		NODE6                      (1-1)
                        	B_NUM      (0-1)
                        	NAME        (0-1)

Former Member
0 Kudos

Hi,

Make sure that

A_NUM Context is assigned to NODE1 and B_NUM is also assigned to NODE1

Regards

Seshagiri

Former Member
0 Kudos

Hi Smitha ,

Do this way -

For A_Num define the context at the level of Node1.

For all other nodes which have B_Num as element set the context to root node.

You get data in queue like this - A_num and context change and after that you will have all nodes as values in single context.

Get the value of A_Num = loop at the B_Num and pass the name value to output.

With the above context set you can write a UDF which will map name to right value in target structure.

Regards,

Kishore

Former Member
0 Kudos

Assign Context of A_Num to parent Node NODE1,

if A_NUM = B_NUM; pass NAME