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
Solved! Go to Solution.
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.
Hello @BillyL14 ,
try connecting to multifield formula tool and configure like the below screenshot.
And for a third solution, you can use the Select tool to Select-> Select All, and change all data types for these fields:
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 : )
thanks everyone