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

raja.arslankhan (Raja Muhammad Arslan khan) September 20, 2022, 10:13pm 5

@gokul1904 I think so Its linq code you should put invoke code Activity.
please try my suggestion

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