Hi team, I am getting below table - [image] join.xlsx (10.2 KB) I want to remove lines when a cost unit occurs in a subsequent series then take from the series the last when a cost unit line doesnt have direct following row with the same cost unit, then block it I only want to select one ro…

[image] gokul1904: it is not returning any rows whereas expected was to skip the 2nd duplicate row just handle outcomes seperated: A: Protoype code in its box where do see the results or fails B: the adapted own implementation For A: show the case of fail by get bound to the sample data sc…

Filtering repeating values in excel join datatable

Help Studio

gokul1904 (Glory 01) September 22, 2022, 12:30pm 19

This worked thanks -
Result = ExtractSegments.Select(Function (x) x.Last()).toList

Topic		Replies	Views
Filter/Select Non Duplicate Values Help datatable , excel , activities , question	15	4243	December 6, 2019
Select unique rows from the datatable and delete repeated rows with conditions Studio studio , question , activities_panel	3	533	September 29, 2022
Filter data Excel Help datatable , excel , activities , question	5	791	November 26, 2019
Remove duplicate rows based on conditions Studio question	13	2535	February 8, 2021
Filtering DataTable for first 5 numbers Activities datatable , excel , activities , studio , question	5	754	June 10, 2021

Filtering repeating values in excel join datatable

Related topics