Question

FeatureWriter not recognizing casting on features, wants to write everything as text.

  • 27 May 2021
  • 1 reply
  • 0 views
A

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!

1 reply

M
Badge +2

@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

28,631
Posts
109,154
Replies
36,508
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.