Changing the data types for all fields

[BillyL14]

Hi

Is there a way of changing the data types of all columns without clicking into all of the fields in the select tool?

I have maybe 100 fields that I need to change to v_string and wondering if there is a faster way

Thanks

[atcodedog05]

Hi @BillyL14 ,

Try AutoField tool.

It automictically converts into best match datatype

https://help.alteryx.com/current/designer/auto-field-tool

Hope this helps : )

If this helps please mark the post as solution.

[ImadZidan · Accepted solution]

Hello @BillyL14 ,

try connecting to multifield formula tool and configure like the below screenshot.

[Per · Accepted solution]

And for a third solution, you can use the Select tool to Select-> Select All, and change all data types for these fields:

[atcodedog05]

Hi @BillyL14 

I can see that @ImadZidan and @Per is the best approach in solving the scenario.

Do not consider mine. It doesn't completely solve the given scenario.

Cheers and Happy Analysing : )

[BillyL14]

thanks everyone