How to get uniqe rows only based on two columns

[StevenIsRobotOnline (Steven)]

Identify Unique rows based on specific columns

Hi @vishal_nachankar , I’d like to confirm your requirement. If input data is as the following, column1,column2,column3,column4 ABC,xxx,123,yyy ABC,xxx,123,yyy AAA,xxx,123,yyy tys,yyy,334,yyy tys,yyy,334,yyy yru,ooo,999,ppp Is expected output still the following? column1, column2,column3,column4 ABC,xxx,123,yyy tys,yyy,343,yyy yru,ooo,999,ppp OR column1,column2,column3,column4 ABC,xxx,123,yyy AAA,xxx,123,yyy tys,yyy,334,yyy yru,ooo,999,ppp If former, the expression will be as the followi…

Hi Guys my question is related to the above post ,
I will need to get all the uniqe rows based on 2 columns
but currently my studio is working in a VB environment

thank you for the help.
Regards
Steve

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @StevenIsRobotOnline ,
They are same,
Can you share your input and expect output?
Regards
LNV

[StevenIsRobotOnline (Steven)]

Input also same as the post above
column1,column2,column3,column4
ABC,xxx,123,yyy
ABC,xxx,123,yyy
AAA,xxx,123,yyy
tys,yyy,334,yyy
tys,yyy,334,yyy
yru,ooo,999,ppp

output also save as above
column1, column2,column3,column4
ABC,xxx,123,yyy
tys,yyy,343,yyy
yru,ooo,999,ppp

thanks

[Yoichi]

Hi,

Can you try the following expression? This creates group from 3 columns. please modify it for your requirement.

dtResult = dt.AsEnumerable().GroupBy(Function(r) Tuple.Create(r("column2").ToString(),r("column3").ToString(),r("column4").ToString())).Select(Function(g) g.First()).CopyToDataTable()

Regards,

[StevenIsRobotOnline (Steven)]

works like a charm thank you