Alteryx designer Discussions

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

Combine Field1 with value of Field 2 ~ 5 and Sum of Field 6 ~ 9 HELP!!!

Meteoroid

Combine Field1 with value of Field 2 ~ 5 and Sum of Field 6 ~ 9 HELP!!!

Highlighted
Alteryx Certified Partner

Hi @jayryan612,

 

Solution is attached. 

 

If each of your columns contains only one value per field1, and all remaining values are null - then taking the MAX of fields 2,3,4 & 5 will return you the desired values along a single row. 

 

Snag_200a84ba.png

 

 

However, if you have messier data with multiple values - then @Thableaus comment on this solution using the tile tool has helped me to remove nulls from complex data sources. 

 

Hope this helps!

Highlighted
Meteoroid

Thank you very much! I have another problem like this but much more data is included. I will try this

Labels