Casting from double to int in c3 transform file

#1

I have a field that is expected to be an integer. However the data comes in as 1.0, 2.0, …
What is the best practice to transform that field into an int (1, 2, 3).
Currently the field definition in the canonical is double and i used “round()” in the transform.
The target field in c3 typ is of type int so I would expect an automatic casting if I don’t specify round() in the transform but it is not the case and it throws an error.

0 Likes

#2

Just in general, I would not expect casting to be a default transformation as it breaks (any) type system.

0 Likes