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.
Hey @Vaib !
Try to use a formula tool with:
IIF(LENGTH(tostring([your field here]))=3,"True","False")
Hope that help!
Hi @Vaib I amended the workflow with a couple or approaches and should produce the output you describe
Hi @Vaib I mocked up a workflow that shows one approach to tackle this. Let me know what you think?
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.
