How to automatically change data type for data having numbers?

[Kartik21]

In my inputs, the data having numbers sometimes come as data type as "VWstring" or sometimes it come as "Double" data type.
I have to manually change the data type using select tool every time , so that the join tool applied in the workflow works fine.

Can anyone please tell, how can the data type can be automatically changed in such scenario?

[Raj]

@Kartik21 
try using Auto field.

[OTrieger · Accepted solution]

@Kartik21 
Or you can set in the Select Tool the Option Forced type of data type and in that way that field will be always in that selected data type.

So if that data type is currently String and that the default format, you can change it to Forced String and then no matter how the data will be the next time it will be sting.

[Qiu]

@Kartik21 
I also agree with the Auto Field tool.

[atcodedog05]

Hi @Kartik21 

I agree with @OTrieger if your data is changing datatypes it's better to force the datatype to required format. Because if datatype keeps changing it can cause your workflow to error.

If the datatype is color yellow like below than its forced datatype.

Hope this helps : )

[Kartik21]

Thanks @atcodedog05  & @OTrieger .It is working fine now.😊