Skip to main content
  • EN

Hello, 

 

I regularly save a file in a GDB (GDB-Name\\Topic_<date>) and want to display the differences a week later. Manually - I enter the file names myself - this works wonderfully, but it always requires a manual intervention to enter the correct names. Now I would like to automate this work. For this purpose, I calculate a variable using the transformer "DateTimeCalculator", which calculates the date of the last execution of the script (-5days). Afterwards I want to read the last table (GDB-Name\\Topic_<date - 5days>) from the GDB using the FeatureReader. My problem now is that I do not manage to specify the correct table within the GDB, or the correct number of features is output at the Generic Port, but without geometry and attributes. So my question is, where can I specifiy the correct tablename? Could someone please help me to solve this problem?

 

17-02-2023_08-13-51

@alfons​ What version of FME are you using? This may have been in issue in earlier versions of FME. I can't reproduce it in FME 2022.2. I've attached an example workspace. Also, it might be that your _result_datetime doesn't have the correct format to match your feature class name. For example if your feature class is: CABLE_CAR_2023_02_17 and your _result_datetime includes H M S then you won't get a match. You might have to use DateTimeConverter to get the right format.

attachment

Reply


Community Stats

30,126
Posts
114,354
Replies
37,759
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.