1

I am having difficulties with a relatively simple task. I have multiple transformers which append an attribute to an "ElementID" coming from different transformers. I would like to merge all outputs into a single table based on the ElementID field thus having a schema like "ElementID","Attribute01, Attribute02, Attribute03 instead of having 3 tables with ElementID, Attribute01 in table 1, and ElementID, Attribute02 in table 2 etc.

Not all ElementIDs have all three attributes..ie there will be missing attributes.

How do I achieve this with FME 2014.

2

Should be simple. You have this:

enter image description here

And you need to get this:

enter image description here

Just:

  • Add the attributes from tables 2 and 3 to table 1
  • Delete tables 2 and 3
  • Make connections to Table 1

Here's a short movie demo: http://screencast.com/t/0zKOWIrstTtG

  • Thank you Mark. This will create three records in Table1. Is there a way to merge all three attributes into one record? – avguchenko Aug 31 '16 at 21:16
  • Yes, the FeatureMerger transformer. Here I would merge using the ElementID as a join key. That would give me one record with three attributes. – Mark Ireland Sep 2 '16 at 14:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.