How to select data type of unknown field

[Polite123]

Hi team,

Need quick help.

I have 4 columns in the form of Quarters Q12022,Q22022,Q32022,Q42022.

Required data type for all 4 columns should be double.

But every quarter new column comes in data type is changed to string.

With every new run the data type of unknow field must be double for Quarter data(Q1........,Q2.... and so on) along with other V_W string columns.

I am using App Macro combination and hence this issue is coming up.

Kindly help

[binuacs]

@Polite123 I think the unknown field is determining the data type based on the field value. I tested the same and I don't find any issue you mentioned. Below are my first run and the second run result.  

[binuacs]

@Polite123 Can you also check the new column has only numeric values

[Polite123]

@binuacs Yes the new column has only numeric values but the output has string data type.

Is therea way to set data type for all columns starting with Q should always have numeric values.

Thanks

[binuacs · Accepted solution]

@Polite123 One option is to use the dynamic select too to select only the fields starting with Q then use the MultiField tool to change the type to double. Attaching a sample workflow for your reference

[Polite123]

@binuacs -You are truly a magician.

Thanks a lot:)