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.
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
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.