Skip to main content
Question

Transformer full join tables - 2017.1 version

  • August 9, 2019
  • 2 replies
  • 3 views
user01
Contributor
Forum|alt.badge.img+2

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 !

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

david_r
Celebrity
  • david_rCelebrity
  • 8394 replies
  • August 9, 2019

If possible, you'll get the best performance by using the SQLExecutor / SQLCreator, by far.

Otherwise look at the following

  • FeatureJoiner (not available in FME 2017)
  • FeatureMerger
  • InlineQuerier
erik_jan
Contributor
Forum|alt.badge.img+22
  • erik_janContributor
  • Contributor
  • 2179 replies
  • August 9, 2019

@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.

Community Stats

32,079
Posts
121,818
Replies
39,714
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.