How to get the common values in a row?

Sreekar_Mulinti · June 22, 2022, 2:30am

i want to check the common values in a row

Yoichi · June 22, 2022, 2:43am

Hi,

Can you share specific example (input and expected output)?

Regards,

Sreekar_Mulinti · June 22, 2022, 2:53am

From this excel

Yoichi · June 22, 2022, 2:57am

HI,

Can you share expected result?

Is it “9845” and “aaa” OR a pair of “9845 aaa” etc?

Regards,

Sreekar_Mulinti · June 22, 2022, 3:01am

9845 and aaa

Sreekar_Mulinti · June 22, 2022, 3:01am

i want to get the common values

Gangadhar_Athili · June 22, 2022, 3:02am

(From d in DT.Asenumerable
Let a = if(d.itemarray.Count=d.itemarray.Distinct().Count,True,False)
Where Not a
Select r = d).Copytodatatable

Output : DT ( Row Contains similar values )

Yoichi · June 22, 2022, 3:09am

Hi,

Can you try the following sample?

String.Join(",",CurrentRow.ItemArray.GroupBy(Function(o) o.ToString).Where(Function(g) g.Count>1).Select(Function(g) g.First().ToString))

Regards,

system · June 25, 2022, 3:10am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.