Solved

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

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

icon

Best answer by david_r 23 February 2023, 16:15

Userlevel 4

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

Userlevel 4

+30

You can use the Transformer Tester.

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

Thanks in Advance,

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

It works! Thank you, it is appreciated.

Userlevel 4

+30

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

Same time :)

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

Sign up