IM-Inventory Transaction not working properly

[barbola]

I tried to copy the sample integration, but it's not working and I don't understand why.

My data is comma separated because using Tab, the columns were not lining up even though I pasted it into Notepad direclty from excel.
Number,BatchID,Date,Item Qty,Site ID
INV00100,PS-04/05/06,4/1/2006,100,500,ONE
INV00100,PS-04/05/06,4/1/2006,100,300,TWO
INV00100,PS-04/05/06,4/1/2006,90,750,THREE
INV00200,PS-04/05/06,4/1/2006,120,100,ONE
INV00300,PS-04/05/06,4/2/2006,101,50,ONE

What I wanted was the first 3 lines to appear on the same Inventory transaction. But instead, I got 3 transactions with the info from the first line in all 3. The next two transactions were correct using the last two lines.

I would appreciate any help because there is minimal help with this unless the integration exactly matches the sample and I don't have alot of time to play around with trial and error.

thanks.

 

[barbola]

As usual, I got it to work.

I had to use the Group By thingy and also had to make "Item" a key. I guess I need to do some more reading...like I have time