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

slecting leading number from a string

AbdulBasit
8 - Asteroid

below are sample of sales 

 

123

234

123

456

567

i need a formula to extract the leading digit from the numbers. 

 

Thank u every one.

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @AbdulBasit 

 

Here is the formula

 

 

Left(Tostring([Field]),1)

 

 

Field is the column name.

 

Workflow:

atcodedog05_0-1606836409702.png

Hope this helps 🙂 Feel to ask if you have any questions


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

 

AbdulBasit
8 - Asteroid

thanku very much. How do i mark your answer as solution i do not see any option over here .

atcodedog05
22 - Nova
22 - Nova

Hi @AbdulBasit 

 

You have posted the question in introduction channel. You need to post the question in main homepage for you to be able mark it as solution.

 

Anyways

 

Happy to help 🙂

 

Cheers and Happy Analysing 😀

 

atcodedog05
22 - Nova
22 - Nova

Hi @AbdulBasit 

 

Your post has been moved to discussion channel. 

Now you will be able to mark the solution🙂

Labels