Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

2 digit record ID

jackdaniels
8 - Asteroid

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?

 

 

5 REPLIES 5
LordNeilLord
15 - Aurora

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


Data Lover

jackdaniels
8 - Asteroid

Thanks @LordNeilLord !

BenMoss
ACE Emeritus
ACE Emeritus

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
8 - Asteroid

Thanks Ben. This is a simpler approach.

LordNeilLord
15 - Aurora

@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

Labels