Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • General
  • In an oracle database I would like to export to excel format a table with a particular filter. I would like to output only the rows containing the most recent date per section. How can I do this on FME?

Example of my database : 

 

Capture 

I am a beginner in FME, thanks for help !

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 = 1

Then send the output to an Excel writer.

Reply


Community Stats

30,163
Posts
114,500
Replies
37,813
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.