Extract data from Filename

[singa]

I'm trying to find a solution for -

From a list of files, that has date in the filename, one of them need to be selected based on the latest date.

Get Files --> Sort --> JavaScript

the Get Files retrieve all the files, Sort by descending order (to identify the top one as the latest one) and the JavaScript to get the actual filename with the latest date on it.

The problem I am facing here is - how to retrieve the one filename from the Sort step. I tried to use 'Select Values' and 'Copy rows to result' and none of them work.

filename.getString() doesn't seem to give only one file name out of the bunch of files in that group.

Please help....

[shassan2]

Hi singa,
Group by step (after sort) should do the trick.
In fact, you can get the first value, the last value,...

Rgds

Samatar

[singa]

Can you please tell me how to pick up the first value from Group By? I could n't do that in Java script by using value.getString(). I need to pick up just one of the file name from the list of files...any help is appreciated

Thanks in advance

[singa]

Thanks samatar for the help I got it

singa