Grouping multiple excel rows in to single queue item

[lrtetala (Lakshman Reddy)]

Hi @Praveen_Vs

Please check on this thread

Multiple input rows in single queue item

we can do it by grouping the data Assign Activity: TableList | List(Of DataTable) = (From d in YourDataTableVar.AsEnumerable() Group d by k=d("ID").toString.Trim into grp=Group Select t = grp.CopyToDataTable).toList Then loop with a for each (not for each row) over TableList e.g. create csv data or any other represenation for the current looped datatable and use it for the WorkQueueItem creation

Hope this helps!!