Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Pri_passion
Contributor
Contributor

Getting latest file from directory?

I want to take the latest file from the directory.

What i am doing is tfilelist>tfileproperty>taggregaterow>tlogrow

in taggregate i am giving mtime as max.

but I am not getting desired result all the file are displaying in console

2 Replies
Pri_passion
Contributor
Contributor
Author

I tried one approch and got the desired result.

In case ,anyone have any other idea let me know.

what i did is:

 

tfilelist -- > tfileproperty --> tbufferoutput

|

subjobOk

|

tbufferinput --> taggregaterow(kept mtime as max and abspath as last) -->tlogrow.

 

 

pakapi_
Creator
Creator

Hi Pri_passion,

 

maybe something like this: https://community.talend.com/s/feed/0D73p000004kFhUCAU

Just change Order by to By modified date, and Order action to DESC in tFileList 🙂

 

Regards