Skip to main content

Hey guys,

 

I've brought some data sources casted through a query (SQLexecutor transformer with a Creator) from a postgresql DB.

 

Applied some transformations, such as AttributeManager, and generated some IDs by adding columns with counters.

 

And the FeatureWriter wants to write everything casted as "Text" on Automatic Attribute Definition. Before I switch to "Manual" and cast everything (again), I just wanted to know if there's a way to have the FeatureWriter recognize the casting brought over from the query.

 

Thanks and all the best!

@asplundh_ds​ at the moment there is no way to preserve the CAST attribute data types. We are working on exposing the schema and types. But it is not possible in FME 2021 or earlier


Reply