Alteryx Designer Desktop Discussions

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

Summarize Data from Multiple Columns and Find the Occurrence

Anirban
6 - Meteoroid

Hi All,

 

I have a data set with various numbers in different columns (Please refer the input data format text file). 


My goal is to consolidate all the numbers from various columns into a single column and count the occurrence of each of those numbers based on a criteria. Here the criteria is the number should be >=500. (Please refer the output data format text file)

 

Please let me know how i can do the same. Thanks in advance for the help.

Anirban

3 REPLIES 3
binuacs
21 - Polaris

@Anirban 

binuacs_0-1643651011105.png

 

binuacs
21 - Polaris

@Anirban I updated the column1 and Count in the first row

binuacs_0-1643651604023.png

 

Anirban
6 - Meteoroid

Thanks a lot. This works perfectly ðŸ™‚

Labels
Top Solution Authors