How can I do a left join of A and B tables using some other Transformer ?
Screenshots will be highly appreciated. Thanks
Question
What transformer to do a left join of table A and table B
I was using FeatureMerger to join a spatial table A and a non spatial table B. I noticed it was an inner join, and I didnt find any option to change it to a left join.
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.
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.
I used the SQLExecutor, and I noticed in the properties of the tranformer, I can specify only one format for the reader. But in my case, I have two formats; one is a posgis and the other is posgresql
Hi,
Since you are using the FeatureMerger, I don't think you need any more special operation.
When REQUESTOR is left table and SUPPLIER is right table, the set union of MERGED features and NOT_MERGED features is equivalent to the lett outer join result.
MERGED --> inner join
MERGED and NOT_MERGED --> left outer join
MERGED and UNREFERENCED --> right outer join
* except case of unconditional merging
Remember the Venn diagram :-) http://en.wikipedia.org/wiki/Venn_diagram
Takashi
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.