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

[tgopalas (Tanuja)]

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

[HareeshMR (Hareesh Madasi)]

@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

[tgopalas (Tanuja)]

@HareeshMR,

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

[AshwinS2 (Ashwin S)]

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

[tgopalas (Tanuja)]

Hi @AshwinS2

Thanks a lot for the response
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

[AshwinS2 (Ashwin S)]

Hi @tgopalas

Please share the screenshot

Thanks
Ashwin S

[tgopalas (Tanuja)]

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

[AshwinS2 (Ashwin S)]

Hi @tgopalas

Take this code

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

Output Datatable print NewDatatable
Thanks
Ashwin S