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

[Iam_sumitkumar]

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 solution]

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 solution]

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 : )

[Iam_sumitkumar]

Thank you! It worked! 

[atcodedog05]

Happy to help : ) @Iam_sumitkumar 

Cheers and have a nice day!