Example of my database :
I am a beginner in FME, thanks for help !
Page 1 / 1
The most efficient is to let Oracle do the filtering for you, e.g using a SQLCreator with something like the following:
SELECT *
FROM (SELECT c.*,
rank() over (partition by "Section" order by "Date" desc) rnk
FROM "MyOracleTable" c)
WHERE rnk = 1Then send the output to an Excel writer.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.