Skip to main content
Solved

Filter by date value - Select date value starting with "2023", "2022", etc.

  • February 23, 2023
  • 5 replies
  • 18 views

In SQL, it's possible to select all your data starting with "2023" like this :

-------------------------------------

SELECT *

FROM mydata

WHERE date LIKE "2023%"

--------------------------------------

Is there a way to do it with FME?

 

I have already apply a "DateTimeConverter" to convert my data in FME format (20230223).

 

I see on FME Workbanch that there is a "SQLCreator", but I need to import my data from a url and not from an DataBase like PostGIS

Best answer by david_r

The easiest is probably to use a Tester with a criteria to check for "starts with".

View original
Did this help you find an answer to your question?

5 replies

david_r
Celebrity
  • Best Answer
  • February 23, 2023

The easiest is probably to use a Tester with a criteria to check for "starts with".


danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • February 23, 2023

Hi @geo.uqam​ 

 

You can use the Transformer Tester.

 

In the configuration of Tester, has a option Begin With.

 

 

Thanks in Advance,

 

 


  • Author
  • February 23, 2023
david_r wrote:

The easiest is probably to use a Tester with a criteria to check for "starts with".

It works! Thank you, it is appreciated.


danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • February 23, 2023
david_r wrote:

The easiest is probably to use a Tester with a criteria to check for "starts with".

Same time :)


  • Author
  • February 23, 2023
danilo_fme wrote:

Same time :)

That was my very first question. Now I know that there is a very active community ready to help. Thank you!😀


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings