We have a problem with the cases of our attributes. Normally the attributes were all uppercase, but we have some customer which send us data where they are not. They sometimes mix the cases in all sort of ways. We have a ArcGIS SDE Reader and a Hexagon SQL Warehouse Writer. Here an example:
Table: WASS_SUBART_HYDR
Attributes: OBJECTID, CODE, DESCRIPTION_G, GlobalId
This is our configuration, but our customer send us data, where the CODE Attributes is lowercase. Then our FME Workbench does not work, because the code Attribute is "ignored" and the writer will write a NULL Value to the Database. If we see it correctly, the problem is, that the reader has the wrong information about the attribute.
Is there a way to ignore the upper- and lowercase of a reader? (If not, this would be a nice feature, because ArcGIS and MS SQL can handle this no matter how it is written)
Or is there a way to change the reader dynamically?
This is only a small example to keep it simple. We have to deal with this problem a lot, not only for attributes but also for table names.
Thank you for helping :)
Best answer by jdh
View original
