How to select data type of unknown field

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

Datasets

Accepted answers

binu_acs

@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

Change_DataType_190223.yxmd

All comments

binu_acs

@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.

binu_acs

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

Polite123

@binu_acs 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

binu_acs

Change_DataType_190223.yxmd

Polite123

@binu_acs -You are truly a magician.

Thanks a lot:)

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703