In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How to replace all values in column to 0

overhead_press
8 - Asteroid

Below I have the sample dataset and I am wondering how do I replace all values to be 0's like my desired dataset? Thanks!

 

Sample: 

6230
17697
8977
3911
03619


 Result:

0000
00000
0000
0000
00000
3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus

@overhead_press  ,

 

 if that's a string then:

 

replacechar([stuff],"123456789",'0')

 

 should work

 

Cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
NexBK
7 - Meteor

Hi, @overhead_press 

If the data type is numeric, change to String, and use the Regex Tool to change all characters (.) to zero.

NexBK_0-1660002064051.png

 

flying008
15 - Aurora

Hi, @overhead_press 

 

 If your field type is string, follow the below formula, if it is number, you need convert to string with tostring([Num])

 

ff.png

Labels
Top Solution Authors