Rookie questions - Parsing numbers

Hello, downloaded Alteryx today and I am having lots of fun with it.

I have a very punctual question. How can I create a workflow to parse a number to detect if it is a palindrome (for example 12321 or 1987891)

Thanks in advance!
Rodrigo

Common Use Cases

Accepted answers

NicoleJohnson

You can create a new field in your formula tool called ReverseNumber (or whatever you want to call it) - the trick is to name the new formula something else using the “+ Add New Field” option rather than selecting the existing field from the drop down for formula name, so that you don’t overwrite whatever is in the original field. Then in the Filter tool, the formula you can use in the custom formula section below would be something like [OriginalNumber] = [ReverseNumber]. For those records that are true for that statement, they will show up in the True output branch. Anything that doesn’t match/isn’t a palindrome will show up in the False branch.

If the formula gives you an error, try adding either ToNumber() or ToString() wrapped around each of the field names, like ToNumber([ReverseNumber]) if the OriginalNumber is a number type, not a string.

NJ

All comments

NicoleJohnson

Try the ReverseString formula! (You might need to wrap a ToString formula around your original numbers as well depending on the field type). You can then use a filter to test if the Reverse version is equal to the original... let us know if that works! And awesome to hear you are having fun with Alteryx!!

Cheers,
NJ

calloni

OMG so many nice features on Alteryx! Thanks Nicole.

The first step worked and I got the reversed numbers. I am looking at the Filter option but don't find how to test it.

Should I create a new file out with the reversed numbers and then blend the original to it and compare?

Thanks NJ!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703