Linq Query question regarding DT

[Shubham_Kinge]

I have a raw data excel, i want a datacolumn from that which should have uniquevalue. i can do it using for each row and adding in seprate column but i want to do it with the liq query, can someone help.

[Jithesh_R]

Hii @Shubham_Kinge ,
what i understood from your requirement is you want a particular column in your excel from which you should get only the unique value. If this is right then you can use below expression.

YourInputDT.DefaultView.ToTable(true,“YourColumnName”)

This will return the single column with the unique values.

Thanks,

[pawanrajpurohit]

Try this one may be this will help you

dtYourDatatable.DefaultView.ToTable(True,“ColumnName”)

[Manish540 (Manish Shettigar)]

Hi @Shubham_Kinge ,

Check this below query to get unique rows based on a column,

dt_Grouped = (From d In dt_Input
Group d By k=d("Your Column Name").toString.Trim Into grp=Group
Select grp.First).CopyToDataTable()

Hope this may help you