Skip to main content
Question

Attribute Value Mapper: Writing to an an exiting column that has a new data type:

  • November 25, 2019
  • 1 reply
  • 5 views

jhawks
Contributor
Forum|alt.badge.img+7

Enterpirse geodatabase in oracle. Exisiting column has a datatype of double with values of 1,2,3 etc. I want to use ValueAttributeMapper to

remap these values to sphere, board, cube etc. If I change the datatype in arcmap from Double to VarChar2 does it need to be empty or will the workbench take care of this? The

Writer currently has Drop Table: No and truncate Table: yes

1 reply

erik_jan
Contributor
Forum|alt.badge.img+19
  • Contributor
  • November 25, 2019

After updating the table in the database, setting the new data type, you can use the Menu item:

Writers > Update Feature Types

To adjust the feature type to the new table definition.

This is the "best practice" way of doing it.

You could also edit the feature type on the User Attributes tab to reflect the right data type.

But the definition in FME must be made to match the database table.

Hope this helps.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings