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. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. 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