2 digit record ID

[jackdaniels]

The record ID tool can only be configured to start at 1, but I need it to start at 01 (or even 001). 

How else can this be achieved?

[LordNeilLord · Accepted solution]

Hey @jackdaniels

You can use the PadLeft function in formula tool to add leading zeros:

PadLeft(ToString([RecordID]), 2, "0")

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[jackdaniels]

Thanks @LordNeilLord !

[BenMoss · Accepted solution]

It can actually be performed easier than this!

In the 'RecordID' tool, set your option-type to be 'string' and the size to 2.

Alteryx will automatically pad the numbers to the length specified.

Ben

[jackdaniels]

Thanks Ben. This is a simpler approach.

[LordNeilLord]

@BenMoss

This is true, however....if you set it to 2 then once you hit 99 alteryx will start to truncate the field.

So you could set the length to 8 or 10 or 12 but you can't do this dynamically...so it seems like a pointless feature