Extract DWG files from Postgres by recent Date

@mr_fme

If you wish to use fme transformer's for that:

Then you can use Statistics Calculator analyse the date filed and group by filename.

As Statistics Calculator works on date fields.

Of course you can do same using a Postgres query:

select max(date)

from table

group by filename

Making sure if I understand you correctly:

In this example the most recent date for the file 158-Maria_Farm_01 is 08-22-2019 so you only want to extract that feature?

No, all feature belonging to 158-Maria_Farm_01 with 08-22-2019 (if most recent), in short means all features from the same dwg file. Example: features with Kind = I, filename = 158-Maria_Farm_01, file_date 08-22-2019...equals same DWG.

I solve my problem using StringReplacer, DateTimeConverter before StatisticCalculator...after FeatureMerger

Thank´s