Skip to main content
  • EN
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.

 

 

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.
Hi,

 

 

have you looked at the Joiner?

 

 

David
I was looking at the SchemaMapper or AttributeValueMapper tools.  There are hundreds of values that need changed to a code
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 hImport] 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 hImport] button in the parameters dialog.

 

 

Takashi
What if the mapping rule is dynamic?

 

 

What if the mapping rule is dynamic?

 

 

Then the schema mapper is a better choice.

 

 

Then the schema mapper is a better choice.

 

 

Thanks Itay!

 

 

Reply


Community Stats

30,133
Posts
114,383
Replies
37,770
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.