on 12-03-2013 4:04 PM
Hi Experts,
URGENT! Action Needed.
I need <PRODUCTID SUPPLIER> to be in respective line items.
For ex:- If <productid> is filled in all line items it works perfect (values are Mapped to respective line item).
ProductID on PO | ProductID on XML |
19252 | 19252 |
159594 | 159594 |
191196 | 191196 |
14321 | 14321 |
But, if <ProductID> is missed in some line items,then there is some mishap. Actually, If it is empty value I want same to be present in respective line item but here in below example <Product ID> line item 40 is getting populated in line item 20.
Line Item | ProductID on PO | ProductID on XML |
10 | TEST VENDOR PRODUCT ID | TEST VENDOR PRODUCT ID |
20 |
| TEST VENDOR PRODUCT ID 2 |
30 |
|
|
40 | TEST VENDOR PRODUCT ID 2 |
|
50 |
|
|
60 |
|
|
Kindly help me on this issue !
Current mapping logic (Screenshot attached) for this <Product ID supplier> :-
if QUALF = 002 then value of IDTNR should be mapped to ProductIDSupplier.
Hi Selvan,
Raise the context for Qualf and IDTNR to higher context above ProductID node.
You can remove 'Remove context' function after if block now.
Regards,
Pranav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Guys,
Thanks for the Effort taken.
Need your help on this below thread also,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tamil,
Why are you using remove context in the map? you can add the map with default in place of remove context.
Regards,
Harish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tamil- try using mapwithdefault function for qualf & idtnr
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
>>Actually, If it is empty value I want same to be present in respective line item but here in below example <Product ID> line item 40 is getting populated in line item 20.
I assume, you want blank xml tag to be created for ProductId** in case qualf in the corresponding line item in not 002?
If yes, then instead of IfwithoutElse, you can use IfThenElse (and also remove "removeContext" and SPB) and in the > "Else" part map Constant() + map IDTNR with "Then" part ( just to be on a safer side u can keep map with default as it is)
Thanks
Amit Srivastava
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.