community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Percentages

Highlighted
Meteoroid

Hi fellow Alteryx users!

 

I'm a new learner to nAlteryx and I am still learning how to use software,

 

I however, have an issue.

 

I have a spreadsheet that contains columns such as Name, In Prep (In precentages) and Completed (In percentages).

 

I'm just trying to get those three columns together (Which I sorta know how to do).

However, everytime I get a 'NULL' written in the tabs which have a zero percentage in them, is there a way I can take out the NULL and just make it out to be a zero? I'm hoping to make a Tableu graph out of the data from Alteryx hence why I kinda need the 'NULL' feature out.

 

Thank you in advance and I hope to hear from you.

 

Kind regards.

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Samad_AC ,

 

you can use the DataCleansing tool to achieve this. Simply connect it to the Input tool, the default option is to replace NULL by 0 for numeric fields. Do this solve your problem?

 

Best regards

 

Roland

Alteryx
Alteryx

@Samad_AC I would use the data cleansing tool then the formula tool to concatenate the columns together. It would look something like this.

 

[Field1]+[Field2]+[Field3]

 

If you can provide a specific sample dataset, I can share the results with you.

Digan
Alteryx
Meteoroid

Thanks a lot, will share a data set tomorrow. 

 

Appreciate the help.

 

Kind regards

SC

Meteoroid

Thank you so much, it works now and looks much smoother. 

 

Kind regards

SC

Labels