on 12-21-2007 11:09 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Kamal,
change the context to root node
regards,
Pavani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.