Hi, I want to join two tables from different data sources based on a common field (one to one relationship). I was able to figure out reading data from the two data sources. which transformer should I use to join these two tables so I can combine the data for further analysis? thanks
Solved
join two tables based on a common field
Best answer by fmelizard
Hi all,
Am I right or since FME2016, we cannot anymore create "Named Database Connections" using FME2015 naming convention?
I remember that the connection name was automatically define as:
user@server:port/databaseSo now on fresh install of FME2016, I cannot set my previous define named connections because chars : and / are no more allowed. So I need to adapt all my scripts or there is a magic trick somewhere?
Thanks for any infos and best regards.
Rémi
+18- Safer
- Best Answer
Hi all,
Am I right or since FME2016, we cannot anymore create "Named Database Connections" using FME2015 naming convention?
I remember that the connection name was automatically define as:
user@server:port/databaseSo now on fresh install of FME2016, I cannot set my previous define named connections because chars : and / are no more allowed. So I need to adapt all my scripts or there is a magic trick somewhere?
Thanks for any infos and best regards.
Rémi
fmelizard wrote:
In general, FeatureMerger is the way to go. IN specific, you may be able to use the Joiner transformer depending on what the two formats in question are. First convince yourself the Joiner doesn't work before you move to FeatureMerger. Knowing your formats and your expected # of rows in each may also be helpful if you can provide.
Thanks for your response. below is more info. One data source is from Oracle. I used SQLCreator to query and read the data. The other data source is ESRI GDB which I used GDB reader to read the data and AttributeCreator/AttributeRemove to get a list of fields I need for combining. right now there are 50,000 records.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.