Alteryx Designer Desktop Discussions

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

Count the data input coulumn

arkimp
8 - Asteroid

I have a Input file and in one column data is repeating..  Need to find the count of each data. 

 

Input:

 

IN

US

US

IN

IN

UK

UK

CAN

 

 

 

 

Output:

 

IN     3

US   2

US   2

IN     3

IN     3

UK   2

UK   2

CAN  1

 

 

 

1 REPLY 1
Felipe_Ribeir0
16 - Nebula

Hi @arkimp 

 

One way of doing this

 

Felipe_Ribeir0_0-1670515200892.png

 

Labels