Compare and set the values from one column to the other in a datatable

Hi all,

Can any one help me achieving the below(screenshot attached) by using LINQ.

Got the result by using for each row… Please let me know the LINQ

@tgopalas,

If you have a formula ready with you, use that directly in the write cell activity and auto fill range to fill the data in entire column

@HareeshMR,

Thanks for the response
No I don’t have any formula…
Would like to do by using linq

Hi @tgopalas

Use this

(From p in dt.Select() where( From q in dt.Select() where string.Join(",",q.ItemArray).Equals(string.Join(",",p.ItemArray)) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable()

Thanks
Ashwin.S

Hi @AshwinS2

Thanks a lot for the response :slightly_smiling_face:
Getting the exception - “Source contain No Datarows” when i used the same Input datatable (above screenshot).
Can you please kindly explain me if I need to make any changes

Hi @tgopalas

Please share the screenshot

Thanks
Ashwin S

Hi @AshwinS2,
The same screenshot which I have already attached.
i.e. Input DataTable

Hi @tgopalas

Take this code

Dataview dview=new dataview(InputDatatable)
NewDatatable=InputDatatable.defaultView.toTable(true)

Output Datatable print NewDatatable
Thanks
Ashwin S