How to convert a columns data type from Double to String

Question

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 · Answer

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

DawnaU · Answer

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

IraWatt · Answer

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