How to convert a columns data type from Double to String

[DawnaU]

I need to convert a columns data type (for a UPC, 13 digits) from a Double to a String. What is the best method to achieve this ?

I have tried a Multi-Field Formula of 

IIF([_CurrentField_]=0,'0', [UPC 13 dig (Product ID)]), however this truncates the output UPC at the "0" within the UPC. I need to convert the entire UPC to a string.

[IraWatt]

Hey @DawnaU,

Use the Select Tool to convert columns data types:

[IraWatt]

@DawnaU If your new to Alteryx I would definitely recommend quickly going through the introductory learning videos: Getting Started Learning Path - Alteryx Community

[DawnaU]

Thank you. We were trying to avoid manually changing the data type as this workflow would be applied to multiple input files.

[IraWatt]

ahh okay @DawnaU can you give an example files/dataset to give an idea of how this could be done dynamically?