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
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.
+21- 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
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.