cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in Graphical Mapping

Former Member
0 Kudos

Hi all,

i have a Graphical mapping logic here

Source Structure:

GS

GP[1]

F1- QI

SDQ

F2- 2

GP[2]

F1- QD

SDQ

F2- 3

GP[3]

F1- PC

CTP

F2- 5.3

GP[4]

F1- AI

SDQ

F2- 4

GS

Target structure:

MT

Material[1]

Qty

Material[2]

Qty

Material[3]

Qty

Material[4]

Price

MT

Here the Material node occurences is 0 to Unb.

For values QI,QD and AI should be a seperate mapping ie) three nodes will be created.

For values 'PC' seperate mapping ie. last node will be created only if F1 receives 'PC' beacause i need to implement the separate mapping logic for a value 'PC'.

If i send the data sequence QI,QD,AI and PC my mapping is working correctly.

MT

Material[1]

Qty 2

Material[2]

Qty 3

Material[3]

Qty 4

Material[4]

Price 5.3

MT

But if i send the the data sequence QI,QD,PC and AI my mapping is not working properly for 'AI'. But for QI,QD and PC mapped correctly.

Output:

MT

Material[1]

Qty 2

Material[2]

Qty 3

Material[4]

Price 5.3

MT

Note: For Value 'AI' , target node Material[3] is completly ignored/not coming.

We used createif function to create the target node in the target structure based on the value 'PC'.

we think that once if mapping executed the value for 'PC', mapping for 'AI' is not executed i.e. it doesn't go back and execute the mapping for 'AI'.

Can you please help me to solve this problem,

Thanks and Regards

Kamal

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Kamal,

I understand that your src is

GS

-


GP

-


F1

-


SDQ/CTP

-


F2

and depending on the value of F1 the target nodes has to be created.

here, by using the createif, u can generate the nodes properly, but the problem arises when u have to get the corressponding values in the feild QTY of your target.

in such a situation, writing a UDF would be better a better option.

Thanks

Hari.

Former Member
0 Kudos

Hi Hari,

Thanks for your Quick reply,

Can you please how to handle in UDF or what should be done in the UDF.

Thanks and Regards

Kamal

Former Member
0 Kudos

Hi Kamal,

Can u please let me know as what from the sorce has to be mapped to QTY in the target.

Former Member
0 Kudos

Hi Hari,

From SDQ -Qty Should be mapped From CTP-Price should be mapped.

Thanks and Rgds,

Kamal

Former Member
0 Kudos

hi Kamal,

change the context to root node

regards,

Pavani