Check if a column is in "000" format

[Vaib]

I am trying to check if a column contains values in "000" format. In Excel VBA I would define it as Format(1, "000"). What alteryx formula can I use to check this.

[JosephSerpis]

Hi @Vaib I mocked up a workflow that shows one approach to tackle this. Let me know what you think?

[Vaib]

Thank you for the prompt response. However, what I am looking for is a bit different. If a column contains values  such as 001, 002, 022, 065, etc. the result should be true. But if the value in column is 1, 2, 65, 58, etc. it should show up as false.

[marcusblackhill · Accepted solution]

Hey @Vaib !

Try to use a formula tool with:

IIF(LENGTH(tostring([your field here]))=3,"True","False")

Hope that help!

[JosephSerpis · Accepted solution]

Hi @Vaib I amended the workflow with a couple or approaches and should produce the output you describe

[Vaib]

Thank you for your help!