i want to check the common values in a row
Can you share specific example (input and expected output)?
From this excel
Can you share expected result?
Is it “9845” and “aaa” OR a pair of “9845 aaa” etc?
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 )
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)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.