How to get the common values in a row?

i want to check the common values in a row

Hi,

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

Regards,

From this excel
image

HI,

Can you share expected result?

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

Regards,

9845 and aaa

i want to get the common values

(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 )

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))

Sample20220622-3.zip (8.7 KB)

Regards,

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