Alteryx Designer Desktop Discussions

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

0 values

Eneida33
7 - Meteor

Hello, 

 

I am trying to create a new column through formula tool. This column should be always 0 as there are no data recorded for it. How can I do that, without having nulls as well. 

 

Thank you in advance!

5 REPLIES 5
AngelosPachis
16 - Nebula

Hi @Eneida33 ,

 

If I understand your question correctly, you can use a formula tool to create that new column and populate it with 0s

 

AngelosPachis_0-1631011590948.png

 

Cheers,

Angelos

DavidThorpe
Alteryx Alumni (Retired)

Adding to @AngelosPachis's solution, if the column already exists, you can use the Data Cleansing tool to replace null values with zeros

 

DavidThorpe_0-1631011769449.png

 

Eneida33
7 - Meteor

Yes that is it.

Thank you so much.

Eneida33
7 - Meteor

Thank you very much for the help.

atcodedog05
22 - Nova
22 - Nova

HI @Eneida33 

 

If the solution author's response helps please don't forget to mark it as a solution.

Cheers and have a nice day 🙂

Labels