Reformat based on data types

Question

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

NickC · Accepted Answer

Hello,

You will want to use the formula tool or the multi formula tool to achieve this.  I have used 2, 1 for the numeric fields and 1 for the string fields.

Workflow attached.

Nick

ZacharyM · Accepted Answer

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.

https://help.alteryx.com/2018.2/DynamicSelect.htm