+1
Hello,
I'm new in practicing FME and didn't find any answer to my question.
I'm using FME version 2017.1 and I want to make a FULL JOIN between 2 tables resulting of the transformation of PostgreSQL (Postgis) database tables.
FeatureJoiner transformer would be the one I need but only avalaible since version 2018. I heard about others transformers but joining only from common columns (inner join,....).
Any idea ?
Thank you !
If possible, you'll get the best performance by using the SQLExecutor / SQLCreator, by far.
Otherwise look at the following
+16
@david_r listed most of the usable transformers.
From the list SQLCreator would be the best if the tables are in the same database.
Another option would be creating a view in the database, using the join, and using the view in the PostGreSQL reader.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
