Hi,
I'd like to reformat each column based on it's data type to create a fixed width file. So e.g. if it's V_String I'd like to pad spaces to a fixed width of 40. If it's an Int I'd like to transform a "123" into a "0000123" and so on. The output data type of all columns would then be a string.
Any ideas?
Thanks! Felix
Solved! Go to Solution.
Thanks!
Another question: do you know how to specify the goal format in Alteryx?
E.g. I'd like to specify that -0.1 is written as "-0000000.10" string.
Follow up question: is it possible to define the format on a more granular level? E.g. for int16 instead of numeric?
You can throw a Dynamic Select in front of the setup that was outlined above - this tool will let you select at a more granular level than the Multi-Field Tool.