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
+1- Contributor
I was looking at the SchemaMapper or AttributeValueMapper tools. There are hundreds of values that need changed to a code
+19- Contributor
- 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
takashi wrote:
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
+16- Supporter
jmoura wrote:
What if the mapping rule is dynamic?
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.