Dynamically change field type

[cjaneczko]

I have a cross tab where the headers are dynamic. They will change at each run of the workflow with the exception of the first two fields. Below is an example of the headers. Type and Year will always be the first two columns, but the numeric columns after it will change numbers, but they will always be numbers. I need to change the data type on all columns that have a number in the header from a V_String to Double. I have a feeling this will require the Dynamic Select tool, but I am not sure how to properly create the formula. 

I am thinking it needs to start as IF REGEXMATCH([NAME], '\d+') THEN ......... This is where I am lost. I need to change those field names that start with digits and have their field types changed to Double???

Type

Year

1000

1500

25000

30000

[FinnCharlton · Accepted solution]

Hi @cjaneczko , you'll have to use the dynamic select to select the fields you want, then a multi-field formula to change the data types:

[FrederikE]

Hey @cjaneczko,

I would solve it using a multi-field tool: 

This will change everything unknown to doubles. 

[binuacs]

@cjaneczko the dynamic select tool should work on your use case

[cjaneczko]

@FinnCharlton This worked perfectly. Thank you.