Skip to main content
Solved

Join each record from one dataset to all records from another

  • September 12, 2022
  • 2 replies
  • 21 views

Hi,

How can I join each feature from one dataset to all features from a second dataset?

Datasets aren't related to each other by any column.

 

list1list2output 

Thanks in advance,

Moisés

Best answer by redgeographics

No FME handy at the moment, but if you set up a FeatureMerger with the same, constant, value for Supplier and Requestor join field, e.g "1" and "1" it should work. Have it handle duplicate suppliers and then explode the list afterwards.

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

redgeographics
Celebrity
Forum|alt.badge.img+59
  • Celebrity
  • 3697 replies
  • Best Answer
  • September 12, 2022

No FME handy at the moment, but if you set up a FeatureMerger with the same, constant, value for Supplier and Requestor join field, e.g "1" and "1" it should work. Have it handle duplicate suppliers and then explode the list afterwards.


  • Author
  • 2 replies
  • September 12, 2022

No FME handy at the moment, but if you set up a FeatureMerger with the same, constant, value for Supplier and Requestor join field, e.g "1" and "1" it should work. Have it handle duplicate suppliers and then explode the list afterwards.

Awesome, it worked! Thanks :D