Change the format type with the "Action" function

[JSABOGAL]

Good morning community, I would like to know what is the correct way to configure the "action" tool so that it changes the type of format within a "select" of a single specific column. In particular I want to be able to choose whether the "Value" column will be "Double" or "FixedDecimal".

[JagdeeshN]

@JSABOGAL  Please check if any of the solutions in the below thread work for your usecase..

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamically-change-data-type-of-fields...

Best,

Jagdeesh

[apathetichell · Accepted solution]

See attached...

It's also fairly straight-forward with a multi-field formula - less so with a select tool which requires editing the raw xml.

[JSABOGAL · Accepted solution]

Lo hice algo parecido usando la misma idea y perfecto.