Dynamically update Datatypes

[kamels]

Hi, 

Is there a way when new columns come into my workflow, they can automatically update to be a fixed decimal or any type of number field? They are currently coming in as V_String and I was hoping that this would be something I wouldn't have to do manually. 

[CoG]

The Auto Field Tool may be useful for you.

[kamels]

Do you have any advice on how to use that? I could not figure out how to use that tool to create a Fixed Decimal, when I ran the workflow nothing changed. 

[jrlindem]

Like @CoG recommended, the Auto Field Tool is a good way to accomplish this.  That said, if there are characters in your field that don't cause Alteryx to automatically detect it as a number field, it's not going to assign Fixed Decimal or Double or Int types....

Another alternative is to use the Field Info tool to help identify the fields that are coming into your workflow, then you can flag them using a formula tool and convert them using the Multi-Field Formula Tool, using a formula like ToNumber([field]) to get the data to act as numbers.  This is a lot more complex, though and harder to illustrate.  Recommend doing some searching on this combo of tools to get what you want.

Hope that points you in the right direction.  -Jay

[flying008]

Hi, @kamels 

Could you please tell me, Was the name of new field is fix or dynamic ?

[kamels]

The field is dynamic. It is the month number and year combined. (For example, March 2025- "0325") It has all 12 months in it at the same time, but it is dynamic because the following year, all the dates will update to "0326" ect.