Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Getting a summary Data



I am trying to learn how to use alteryx. I added three files here. I know to how to get to my "output-test" file numbers using excel. I am just trying to figure out if I want to do the same thing on alteryx, how do i do it?


Thanks in advance. 

Alteryx Partner

Hello. Look my workflow. Only replace the location of Excel, but remember: Alteryx isnt Excel, but you can emulate that. Good Luck!!!

Alteryx Certified Partner

Hi @rrahman ,


Just spotted that @atrozz beat me to answering you but I thought I'd post up my contribution anyway. I've added some annotations to help explain what happens at each stage.


There are some data issues in your input files which you can deal with easily within Alteryx, but to avoid complicating things I've processed your data "as is" with only a small fix to account for different cases.




Screenshot 2019-04-04 at 20.49.25.png


Thanks was very helpful. Thanksssss :D