Write unique value in the Columns

[Shyam_Pragash]

Hi Team,

One of the Datatable having one columns “AllUserName” has multiple name in a single cell.

So that i want to write a unique name as showing some sample input and expected output details

Thanks
Shyam

[supriya117 (Supriya Allada)]

Hi @Shyam_Pragash

Try this:

outputDataTable = (From row In inputDataTable.AsEnumerable()
                   Let uniqueNames = String.Join(",", row.Field(Of String)("AllUserName").Split(",").Distinct())
                   Select outputDataTable.Rows.Add(uniqueNames)).CopyToDataTable()

[lrtetala (Lakshman Reddy)]

Hi @Shyam_Pragash

Try this

Code:

(From row In DT.AsEnumerable()
                       Let uniqueNames = String.Join(",", row("AllUserName").ToString().Split(","c).Select(Function(name) name.Trim()).Distinct())
                       Select DT.Clone.Rows.Add({uniqueNames})).CopyToDataTable()

I/P:

O/P:

Hope this helps!!

[Shyam_Pragash]

Hi @supriya117 @lrtetala

Thanks its working fine…