Filter collection in Excel

[Uthaiah]

Dear,
I have a collection, which has Multiple customer and order numbers. Except the header, nothing is constant. So, my BP should identify the same customer numbers and pick the order numbers against it and process with the submission, and then come back, pick 2nd similar customer num and order numbers, then process.. So on.. it will run through web application. Could you pls help?

 

[nbargaje]

Hey,

1. add loop for this collection.
2. use [collection.cust Num]----it will give you cust number. (u can store it in any text variable)
3. use [collection.order num]----it will give order number. (u can store it in any text variable)
4. add your submission process. (use that appropriate text variables)
5. end loop.

it will run for all items in your collection. please let me know if i answered correctly or if you are asking anything else.

Thanks,
Nitin.

 

[Uthaiah]

Hey,

1. add loop for this collection.
2. use [collection.cust Num]----it will give you cust number. (u can store it in any text variable)
3. use [collection.order num]----it will give order number. (u can store it in any text variable)
4. add your submission process. (use that appropriate text variables)
5. end loop.

it will run for all items in your collection. please let me know if i answered correctly or if you are asking anything else.

Thanks,
Nitin.

I am trying to do the above, however, I want one/similar set of customer number with differnt order numbers should go at once for submission.

 

[Gloryjoseph]

1. Get Unique "Customer Numbers" using Code stage (Collection_Out=Collection_In.DefaultView.ToTable(true,ColumnName) OutPut Collection Name: UniqueCustNum , Input : CollectionName - Customer Num
2 Add Loop for UniqueCustNum
3. Filter Collection for each customer : CollectionName : Customer Num , Filter : ""[Cust Num] = '" & [UniqueCustNum.Cust Num] & "'", OutPut : FilteredCollection (FilteredCollection will contain particular customer Data)
4. Add Loop for FilteredCollection
5. Get and enter each Order data [FilteredCollection.Order Num]
6. End Loop for FilteredCollection
7. Submission Stage
8. End Loop for UniqueCustNum
Attached screenshot and xml for ur reference

 

[Uthaiah]

1. Get Unique "Customer Numbers" using Code stage (Collection_Out=Collection_In.DefaultView.ToTable(true,ColumnName) OutPut Collection Name: UniqueCustNum , Input : CollectionName - Customer Num
2 Add Loop for UniqueCustNum
3. Filter Collection for each customer : CollectionName : Customer Num , Filter : ""[Cust Num] = '" & [UniqueCustNum.Cust Num] & "'", OutPut : FilteredCollection (FilteredCollection will contain particular customer Data)
4. Add Loop for FilteredCollection
5. Get and enter each Order data [FilteredCollection.Order Num]
6. End Loop for FilteredCollection
7. Submission Stage
8. End Loop for UniqueCustNum
Attached screenshot and xml for ur reference

thank you so much.. this is just perfect.. Much appreciate it.