Segregate Similar set of the Data using Linq

[shivarajvp555 (SK)]

Hello everyone,

I have data table as shown below :

i need to perform the following steps :

1. I have to segregate the data based on Invoice code and invoice currency, for example for the first one where i have Invoice code (A) and Invoice currencyc(AUD) both are same. I have to segregate this.
2. One segregated, here the invoice number is unique for each of the row. i have to make this invoice numbers as list. since they fall under same invoice code category.
3. I have to push this to Queue. The queue should be created in such a way that all the invoice number under same Invoice code category should come in one transaction with all the invoice numbers as a list.

kindly let me know you thought on making this the easier and simpler solution as possible.Appreciate your responses. Thank you!

[ppr (Peter Preuss)]

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…

[Vikas_M]

hey @shivarajvp555
Refer the below xaml it is similar to your use case
Linq_Assignment2.zip (30.1 KB)

Hope it helps you

[shivarajvp555 (SK)]

Hi @vikas_M can you Please reshare this whole project you have created as i am not able to open it.

Regards,
Shivappa

[Vikas_M]

@shivarajvp555

Sure , below is the file
Linq_Assignment2.zip (30.1 KB)