How to add data into Queue if for one item there are multiple entries

Help Studio
1

Hi,

image
image1150Ă—502 35 KB

As we can see in the above screenshot for one vendor number there are multiple email Address
For ex: 104166 vendor number there are two email addresses.
so for one a vendor I want to add two email addresses in one Queue.

How to do this?

2

@sambulkar I can suggest you to Group By and Combine the Emails, Hence It will appear as One Vendor with Two mail addresses in a Single row, and then you can directly add the Email and Vendor as a String into the Queue.

2 Likes
3

Could you please explained how to do this?

4

Create a sequence for changing your excell file
You have just to add a collumn and asign to it 1,2,3…
it will be a temporary id.
and here you can process data one by one.

1 Like
5

@sambulkar Can you try the Following Steps :
1.Read the Excel File, Get the Output as Datatable, say DT.

  1. Use an Assign Activity in this way :
    DT = (From p In dt.AsEnumerable() Group By x= New With { Key.a =p.Item(“Vendor”)} Into Grp = Group Select dt.Clone.LoadDataRow (New Object() {grp(0)(0),String.Join(“;”,grp.select(Function(c) c(“E-Mail”).ToString))},False)).CopyToDataTable

  2. The Resulting Datatable i.e DT, will have GroupedDT, You can Check the DT by Writing it to an Excel File using Write range, where the emails are separated using a semicolon " ; "

  3. You can Iterate it and Add to the Queue on by one by specifying the Details in ItemInformation Parameter.

2 Likes