on 2010 Jul 08 9:07 PM
I have a Tuple table in a main table with 2 colums: material number & quantity, after the intial full load when ever the quantity for a particular material changes and when we get delta load, instead of updating the quantity in tuple table, its writing new row in the list ie now we are having 2 records with same material number but different quantity, what should i do inorder to update quantity instead of writing a new record for same material number..., did any one faced this issue, please guide me ..........
HI Srinivas,
Try the following steps
1. In import manager ,right click on field of type tuple and select "select tuple update".
2. put "material number" field in matching field selection and quantity in available section.
3. For new records set create and for "existing records" select all update mapped fields option from drop down.
Then import your file.
Please check these stpes at yr end and revert back with results.
This will solve yr problem.
Thanks,
Sudhanshu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I feel you have not set the tuple update options correctly.. Check and try by setting update option to Update (All Mapped Fields) or Replace (*as per your requirement).
Please check Import manager guide using below link (page no 263) for more details
Kindly revert if you face any issues.
Best Regards,
Shiv
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I just want to double check and make sure we are on same page. I was talking about Tuple Update option and not the dafault import action of Match tab of import manger..
I mean, in the Map Fields/Values tab of import manager, right click on the destination tuple and check the update option there.
Best Regards,
Shiv
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
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.