For example. Read the Type Column find the value UNKNOWN look at the look up table and change UNKNOWN to UNK and send to destination database.
Solved
Look Up Tables
+1- Contributor
I would like to have the attribute values in my source data compared to values in an external look up table and changed based on the values in the look up table and then have the new values populated in a different database.
Best answer by takashi
Hi,
View original
If the mapping rule is static, it can be imported to the AttributeValueMapper setting from an external look up table. Have a look at the [Import] button in the parameters dialog.
Takashi
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.
+1- Contributor
I was looking at the SchemaMapper or AttributeValueMapper tools. There are hundreds of values that need changed to a code
- Best Answer
Hi,
If the mapping rule is static, it can be imported to the AttributeValueMapper setting from an external look up table. Have a look at the [Import] button in the parameters dialog.
Takashi
Hi,
If the mapping rule is static, it can be imported to the AttributeValueMapper setting from an external look up table. Have a look at the [Import] button in the parameters dialog.
Takashi
