04-03-20 12:06 PM
Answered! Go to Answer.
05-03-20 08:05 AM
Dim c As Integer c=Cint(cNumber) Collection_Out = Collection_In.AsEnumerable().GroupBy(Function(row) row(c)).[Select](Function(group) group.First()).CopyToDataTable()
Add cNumber as Number Input referring to column number starting from index 0
ALso add following to Imports
04-03-20 01:18 PM
Hi, Mateusz.
You can try to use the asset from Digital Exchange called Millicom – Collection Utility.
You can find the action the extract unique values (or remove duplicates) from a collection and other nice actions to work with collections.
|
04-03-20 01:26 PM
04-03-20 01:42 PM
04-03-20 01:43 PM
I think you can use DISTINCT to get the result you need.
Try it and lets see if works.
|
04-03-20 02:04 PM
04-03-20 03:14 PM
I understand.
In that particular case, you can use a simple loop logic to get unique values from the collection.
Simple loop logic should use
This logic is high time consuming depending of the numbers of rows in your collection, but it will work.
|
05-03-20 06:42 AM
05-03-20 08:05 AM
Dim c As Integer c=Cint(cNumber) Collection_Out = Collection_In.AsEnumerable().GroupBy(Function(row) row(c)).[Select](Function(group) group.First()).CopyToDataTable()
Add cNumber as Number Input referring to column number starting from index 0
ALso add following to Imports
05-03-20 01:02 PM