on 01-12-2008 8:58 AM
Hi,
I have a inbound scenario where I will get bill level details from all the stores (store#, date, item1, quantity1, amount1, item2, quantity2, amount2.....) .I have to aggregate the data for each store seperately and post it into SAP.
please let me know how to handle this scenario in XI.
Example:
Input file1:
Store#1001 (bill#1)
Item1# Quantity1 amount
11 10 100
12 20 200
Input file2:
Store#1001 (bill#2)
Item1# Quantity1 amount
17 70 700
12 80 800
Input file3:
Store#2001(bill#1)
Item1# Quantity1 amount
12 30 300
13 40 400
Input file4:
Store#2001(bill#2)
Item1# Quantity1 amount
19 90 900
13 60 600
output file1:
Store#1001
Item1# Quantity1 amount
11 10 100
12 100 1000
17 70 700
output file2:
Store#2001
Item1# Quantity1 amount
12 30 300
13 100 1000
19 90 900
Edited by: rajesh shaik on Jan 12, 2008 9:59 AM
Hi Rajesh,
In which format are you getting the incoming file.
-Sudhir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.