In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Adding new columns for sum of occurrences

jpbonilla
6 - Meteoroid

Hi. I have several columns and would like to sum the occurrences into new columns, if they contain the required criteria.  Thank you.

 

Example.

RC01RC02RC03RC04RC05RC06RC07...Total_44sTotal_45sTotal30s
424445124   11 
65283044444545 221
67292860626370    
2844      1  
2845       1 
65454545     3 
28303050525560   2

 

2 REPLIES 2
Tiffyyy
Alteryx
Alteryx

Hi, 

 

I hope this solution helps you. 

jpbonilla
6 - Meteoroid

Works! Appreciate your help, @Tiffyyy

Labels
Top Solution Authors