LINQ query to separate rows based on Col name

Help Studio
, , , ,
1

LINQ query to separate rows based on duplicated Column value into other datatable.
As in screenshot, its MainDt. After seperating Dt1 should have row3 and Dt2 should have row2&4
image

2

There are many forum posts about LINQ

Follow this pls

Or use “Filter Data Table” activity - it was created to ease life of “citizen programmers”

Cheers

3

Hi @TrinadhB ,

It seems to be a Group By Case on the Description column. Do you want to Identify the Duplicates based on the Description Column ?

We can suggest you the solution approach if you could provide us more accurate details on the requirement.

4

Identify any duplicate in description column and then separate those rows

5

hi @supermanPunch
Yes, based on Description column

6

Lets assume to split into different datatables:

Assign Activity:
TableList | List (Of DataTable) =

(From d in YourDTVar.AsEnumerable()
Group d by k=d("Description").toString.ToUpper.Trim into grp = Group
Select t = grp.CopyToDataTable).ToList
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.