Skip to main content
Question

Question on multiple joiner

  • February 26, 2018
  • 3 replies
  • 11 views
geo-x
Supporter
Forum|alt.badge.img+6

Dear FME community.

I've two datasets :

Table 1

Col1Col2Col3AnullnullnullnullnullABnullABC

Table 2

Col1Col2AArt of theaterBBlizzardCCute rabbit

What I want is to transform Table 1 in :

Col1Col2Col3Art of theaternullnullnullnullnullArt of theaterBlizzardnullArt of theaterBlizzardCute rabbit

I began to use FeatureMerge but it seems to be "heavy artillery" for a little problem.

What is the best process for resolve this ?

Thank you for your help.

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.

3 replies

david_r
Celebrity
  • david_rCelebrity
  • 8394 replies
  • February 26, 2018

I think the FeatureMerger would be a good choice, personally.

geo-x
Supporter
Forum|alt.badge.img+6
  • geo-xSupporter
  • Author
  • Supporter
  • 89 replies
  • February 26, 2018
What I do like that

 

M
Forum|alt.badge.img+2
  • markatsafe
  • 1891 replies
  • March 2, 2018

The FeatureMerger is a good solution. However it will be limiting if you don't know how many look ups you're going to need in Table 2 or columns in Table1. You can take a slightly different approach by splitting the records up by column (AttributeExploder) , do a single lookup, and then re-aggregate. (we use a siilar approach to transpose data)

I've attached an example workspace (2017): table-lookup-2017.fmwt

Community Stats

32,087
Posts
121,855
Replies
39,729
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.