Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Adding a decimal point waterfall to specific string

AYXEnthusiast
5 - Atom

Hello, 

 

Attached below is a snip containing a subset of the data I am using. My ultimate goal is to add a decimal point to the end of each four digit number that is unique to the Account Description (found after the dash).

 

For example, I want 1200.1 for (Blank), 1200.2 for Accrued Fringe Benefits, 1200.3 for Accrued Payroll, etc. Any tips? 

 

AYXEnthusiast_0-1619735481187.png

 

Thank you!

 

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@AYXEnthusiast 
Hope I get you right. 😁

Capture4.PNG

apathetichell
20 - Arcturus

If (hypothetically) you are about to say - wow! @Qiu your workflow is awesome - but I need the New Account # in Category too, and can the base column be 0 and counting starts with 1 after that for each sub-category?

 

Note - mass of this workflow was done by @Qiu  and I borrowed it.

RaviP
8 - Asteroid

Slightly different approach to @Qiu and @apathetichell.

 

Hope this works as well @AYXEnthusiast 

 

RaviP_0-1619758580261.png

Edit:

 

RaviP_0-1619759217375.png

 

 

 

Labels
Top Solution Authors