Alteryx Designer Desktop Discussions

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

Removing Nulls

romachainani
6 - Meteoroid

This is what I have:

Sum ValuesSum Sum Values
[Null]3345
12345[Null]

 

This is what I need:

Sum ValuesSum Sum Values
123453345

 

I basically need to remove those nulls. It's a simple ask, but not sure why I can't get it right now. Ty for the help!!!

2 REPLIES 2
Prometheus
12 - Quasar

@romachainani I used a Transpose tool to put all the values into one column -- Value. Then the Filter tool to not allow nulls to pass. Then finished with the Cross Tab tool to repivot the data.

TP.PNG

 

Value Not Null.PNG

 

CT SumValues.PNG

 

binuacs
21 - Polaris

@romachainani Another option with the summaries tool

image.png

Labels
Top Solution Authors