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.
Solved! Go to Solution.
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
@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.
Thanks a lot, will share a data set tomorrow.
Appreciate the help.
Kind regards
SC
Thank you so much, it works now and looks much smoother.
Kind regards
SC