Hi, I have an address_point base table that I would like to join with 10+ other tables. They all have a shared column called UPRN.
Is there a better way than stringing together a series of 10+ FeatureJoiners?
Question
Best method to join 10+ tables together based on a shared column?
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.
Do all these tables reside in the same database, and does it support SQL? If so, my preference by far would be to use the SQLExecutor and do the join in the database.
Other than that I'd probably look at using a single InlineQuerier with an input port for each table.
+23- Influencer
Inside FME, Aggregator with mode “attributes only”, grouping by that attribute and set to keep all attributes.
This is also assume that the fields in those tables are unique (although you could bulkattributerename to give them all a prefix if required)
+4- Contributor
Inside FME, Aggregator with mode “attributes only”, grouping by that attribute and set to keep all attributes.
This is also assume that the fields in those tables are unique (although you could bulkattributerename to give them all a prefix if required)
+4- Contributor
I cant seem to find the correct settings as you describe above? This is an example spreadsheet where I am trying to join sheet 2 and 3 to sheet 1. All have the UPRN column in common. Is it possible? I get an error.
+4- Contributor
I cant seem to find the correct settings as you describe above? This is an example spreadsheet where I am trying to join sheet 2 and 3 to sheet 1. All have the UPRN column in common. Is it possible? I get an error.
+4- Contributor
I cant seem to find the correct settings as you describe above? This is an example spreadsheet where I am trying to join sheet 2 and 3 to sheet 1. All have the UPRN column in common. Is it possible? I get an error.
