Skip to main content
  • EN

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


Community Stats

30,122
Posts
114,333
Replies
37,751
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.