cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use to use Text Explorer to glean valuable information from text data at April 25 webinar.
Choose Language Hide Translation Bar
View Original Published Thread

rows selection

Ross_ST
Level I

Dear all,
I am writing to solve a problem about rows selection in data table I have obtained by import of Current-Voltage data of a set of samples. .

final Data table is made by three columns: Current, Voltage, File Name.

I want to clean the Table from the last row of each group of data corresponding to the same FileName.

It is possible?

Thank you

Ross

 

1 REPLY 1
txnelson
Super User


Re: rows selection

I am not quite sure what you mean when you say "I want to clean the Table".  Here is a short piece of JSL that will find the last row for each of the FileNames

Names Default To Here( 1 );
dt = Current Data Table();

dt << select where( Row() == Col Max( Row(), :FileName ) );

Is this providing you the information you need?

Jim