Segregate excel data

[Rreddy]

Hi everyone, i got struck in Writing LINQ query to segregate data.
I have a datatable in that it’s having duplicate data. I need to segregate them each unique data as one list of data then i need use it another place.

I tried some LINQ query but it didn’t worked

DT.AsEnumerable().Select(Function(row) row.Field(Of Integer)(1)).Distinct().ToList()

Input data:

Output: need in for each loop

Set 1:
1
1
1

Set2 :
2
2
2

Set 3:
3
3
3

Set 4:
4
4
4

Set 5:
5
5
5
5
5
5

[Anil_G (Anil Gorthi)]

@Rreddy

Use dt.AsEnumerable.GroupBy(function(x) x("Val").ToString).ToDictionary(function(x) x.Key,function(y) y.CopyToDataTable)

This would give a dictionary of datatable …key would be each value and value would be the corresponding datatable

Cheers

[Rreddy]

Hi @Anil_G how to loop this data in for each activity
I want each set as a datatable in loop.

Example:

Set 1:
1
1
1

In for each i need above values as datatable

[Anil_G (Anil Gorthi)]

@Rreddy

just use thhe above linq query in list of items in for each…

inside for each currentitem.Value will give datatable of each group for each iteration

cheers

[Rreddy]

@Anil_G is this correct

[Anil_G (Anil Gorthi)]

@Rreddy

it is not a list…it should dictionary(string,Datatable)

cheers

[Rreddy]

@Anil_G i tried same
I gave type argument as

system.collections.generic.dictionary<system.string, system.data.datatable>

But still getting this

[Anil_G (Anil Gorthi)]

@Rreddy

Its value not values …remove s

Cheers

[Rreddy]

@Anil_G
I’m not getting value. That’s why using Values. I’m getting only values there. Is there any imports missing in my code for not getting this

Compiler error(s) encountered processing expression “item.Value”.

‘Value’ is not a member of 'System.Collections.Generic.Dictionary(Of String, System.Data.DataTable)

[Anil_G (Anil Gorthi)]

@Rreddy

In the list of items…add .Values

And then change type argument to datatable

And use currentitem directly as datatable

Cheers

[Rreddy]

Thanks @Anil_G it’s working