Change a schema attribute based on a schema attribute value in the source
Article Number: 000001210 - Last Modified: Jul 11, 2011
How to change the schema based on a value from your schema attributes. In the attached workspace example, the data type of fme_decimal would not carry through from a csv to SDE_Geodatabase since the number of digits in the field exceeded the allowable 38 digits defined by the schema of the SDE_geodatabase.
The fme_data_type of fme_decimal needed to be changed to a value of varchar to accommodate attribute values which exceed the allowable number of digits for the destination data type of the writer chosen (SDE Geodatabase in this case).
To do this, define a custom format using workbench which can read the schema, search for the schema attribute fme_data_type with values of fme_decimal and change them to varchar. (Explode the schema list coming from the schema reader, string search for value of fme_decimal in fme_data_type, create a new attribute fme_data_type with value varchar and rebuild list)
Your browser may not support display of this image.
The custom format is then used as a workspace resource in the translation workspace which converts from CSV to SDE_Geodatabase.
Your browser may not support display of this image.
|
Suggested Similar Articles