Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Add decimal point after first character

EJ_Alt
7 - Meteor

Hi Guys

 

I am trying to add a decimal point to my number column e.g.

 

001233435  to 0.01233435

0045678 to 0.045678

40004569023 to 4.004569023

 

the len of number can vary but i simply want to add a decimal point after the first character.

 

Thanks

2 REPLIES 2
CKP
10 - Fireball

Hi @EJ_Alt 

 

This workflow will add a decimal after the first digit.

 

Add Decimal.jpg

 

I hope this helps

EJ_Alt
7 - Meteor

Thanks CKP. 

Labels