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


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


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()


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

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)

Output Datatable print NewDatatable
Ashwin S