Field length for a flat file output

[hholland]

I'm trying to figure out how to set a specific field length for fields before creating my flat file output. The issue is with numeric fields, string fields appear to be working. I tried changing the data type and size of the specific fields in the formula and select tools however the length of the numeric fields are still incorrect.

The Constant field below should be length = 1 instead of 3

The Customer Number below should be length of 12 instead of 20.

<field name="Constant" type="Byte" length="3"/>
<field name="State / County Code" type="String" length="5"/>
<field name="Customer Number" type="Int64" length="20"/>
<field name="Flood Indicator" type="String" length="1"/>
<field name="Transaction Code" type="Byte" length="3"/>
<field name="Billing Cost Center" type="String" length="12"/>

Thanks

Heather

[RishiK]

@hholland for the numerics you could use a FixedDecimal (length.0) if that provides further precision.

Another option is to potentially use the Autofield tool before you output the data

[hholland]

@RishiK The FixedDecimal (length.0) is working great! Thanks so much for your help. 🙂

[RishiK · Accepted solution]

@hholland great. If you can mark the suggestion as a solution so that others will find it useful too. Glad it helped!