Transform a numeric attribute from (40,6) to (38, 6)

Question

I am using a query output as an Input to the workflow. There are aggregation done in the query. Alteryx by size the column as fixeddecimal(40,6). The target database column is of length (38,6). How can I reduce the alteryx input column size from (40,6) to (38,6)?

Jean-Balteryx · Accepted Answer

Hi @Iam_sumitkumar ,

You can use a Select tool to change the type or your fields. in those type there is FixedDecimal which you can change its size.

atcodedog05 · Accepted Answer

Hi @Iam_sumitkumar

You can use select tool to change datatype to fixed decimal points.

If this doesnt work let us know.

Hope this helps : )