In this excel file, Instead of adding each row as a queue item, I want to add multiple rows in to single queue item.
For example : In the Product column, All Lenovo rows need to be added in single queue item, Then in the process state i need to process the grouped rows in queue item one by one.
Is there any way to achieve this ?
Attached the excel file.
If serial number is unique…then add all the serials for lenovo for example as comma separated valeus and then when retrieved get the data from excel using serial
Or
You can add the row by serializing all the rows together and then add the serialized string output to queue item
Each interation will create a group member set table
LINQ Approach
Assign Activity
Groups | List(Of DataTable) =
(From d in dtDataOrig.AsEnumerable
Group d by k=d(GroupColNameOrIndex).toString.ToUpper.Trim into grp=Group
Select t=grp.CopyToDataTable).toList
Also Non-LINQ / LINQ can be combined into an hybride approach