Skip to main content
Question

Best method to join 10+ tables together based on a shared column?

  • December 10, 2020
  • 8 replies
  • 132 views

sar_copp
Contributor
Forum|alt.badge.img+4

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?

8 replies

david_r
Celebrity
  • December 10, 2020

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.


todd_davis
Influencer
Forum|alt.badge.img+22
  • Influencer
  • December 10, 2020

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)


Forum|alt.badge.img+2
  • December 10, 2020

@sar_copp​ Also, you can throw all the tables into FeatureMerger, provided the Requester table is a 'parent' table that has all the ID's that would be found in the 'child' tables entering Suppliers. But I'd follow @david_r​  advice with SQLexecutor or InlineQuerier if you are familiar with SQL


sar_copp
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • December 11, 2020
todd_davis wrote:

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)

Feature Merger


sar_copp
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • December 11, 2020
sar_copp wrote:

Feature Merger

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.


sar_copp
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • December 11, 2020
markatsafe wrote:

@sar_copp​ Also, you can throw all the tables into FeatureMerger, provided the Requester table is a 'parent' table that has all the ID's that would be found in the 'child' tables entering Suppliers. But I'd follow @david_r​  advice with SQLexecutor or InlineQuerier if you are familiar with SQL

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.


sar_copp
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • December 11, 2020
sar_copp wrote:

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.

Feature Merger


Forum|alt.badge.img+2
  • December 11, 2020
sar_copp wrote:

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.

@sar_copp​  are you able to attach a small example of the data?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings