Reverse a Number in each row

Hi all,

I'm fairly new to Alteryx and i'm having an issue with a number - i need to reverse numbers in a column using Alteryx but cannot seem to figure out how to do this.

I have a set of numbers in each row -

Example

Number Expected Reverse Result

123456 654321

789456 654987

741852 258147

Reporting

Tips and Tricks

Accepted answers

LordNeilLord

Hey @berty

You could try:

ToNumber(ReverseString(tostring([Number])))

All comments

LordNeilLord

Hey @berty

You could try:

ToNumber(ReverseString(tostring([Number])))

ChrisTX

This might help in the future, to identify a Function for a specific purpose.

This page lists all Functions:

https://help.alteryx.com/current/Reference/Functions.htm

Under the Search box, if you click the 3rd icon for Expand All, you can then search for "reverse" to find information on the ReverseString function.

berty

Just a quick question, I noticed on some of my values it didn't carry through correctly for example serial code 00000879 translated as 978 but in reality it should be a min of 4 - therefore should show 9870 - (note the other serials could be 5 or 6 character long but where a 0 is on the 4th character it drops. is there a way around this?

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335