I am using FME joiner to join tables. the joined tables do not show all fields from the source table. I was wondering what could be the reason. Any help would be greatly appreciated.
Solved
FMEJoiner
+12- Enthusiast
Best answer by redgeographics
i have some attributes with the same name like UDF1 and UDF 2in both layers, but the joined table only gives me one set of these attributes, i have to actually transfer these attributes from one feature to another.
Right, you have the FeatureJoiner set up so that in case of attribute conflicts it'll take the ones from the "Left" input. So it's working as intended. If you want to keep both sets you should take the data flowing into the "Right" input and rename those attributes, e.g. via a BulkAttributeRenamer where you select those attributes and prefix or suffix them.
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.
+65- Celebrity
Hi, are you meaning the FeatureJoiner? That should auto populate all attributes present in your inputs
+62- Celebrity
Can you share a screenshot of your workspace and the settings of the Joiner? Is it actually a Joiner and not a FeatureJoiner like @hkingsbury​ mentioned? The Joiner was phased out many years ago.
+12- Enthusiast
I am using FeatureJoiner to join tables. I am attaching some screenshots of the workspace.
+62- Celebrity
I am using FeatureJoiner to join tables. I am attaching some screenshots of the workspace.
So which attributes are not coming out of the FeatureJoiner?
+12- Enthusiast
i have some attributes with the same name like UDF1 and UDF 2in both layers, but the joined table only gives me one set of these attributes, i have to actually transfer these attributes from one feature to another.
+62- Celebrity
- Best Answer
i have some attributes with the same name like UDF1 and UDF 2in both layers, but the joined table only gives me one set of these attributes, i have to actually transfer these attributes from one feature to another.
Right, you have the FeatureJoiner set up so that in case of attribute conflicts it'll take the ones from the "Left" input. So it's working as intended. If you want to keep both sets you should take the data flowing into the "Right" input and rename those attributes, e.g. via a BulkAttributeRenamer where you select those attributes and prefix or suffix them.
+12- Enthusiast
Right, you have the FeatureJoiner set up so that in case of attribute conflicts it'll take the ones from the "Left" input. So it's working as intended. If you want to keep both sets you should take the data flowing into the "Right" input and rename those attributes, e.g. via a BulkAttributeRenamer where you select those attributes and prefix or suffix them.
that worked! thank you!
+62- Celebrity
Right, you have the FeatureJoiner set up so that in case of attribute conflicts it'll take the ones from the "Left" input. So it's working as intended. If you want to keep both sets you should take the data flowing into the "Right" input and rename those attributes, e.g. via a BulkAttributeRenamer where you select those attributes and prefix or suffix them.
You're welcome!
+12- Enthusiast
Hi, are you meaning the FeatureJoiner? That should auto populate all attributes present in your inputs
thank you for your help!