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