Getting a summary Data

[rrahman]

Hello,

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. 

[atrozz]

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

[jamielaird · Accepted solution]

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.

Cheers

[rrahman]

Thanks was very helpful. Thanksssss :D