Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Getting a summary Data

rrahman
6 - Meteoroid

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. 

3 REPLIES 3
atrozz
8 - Asteroid

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

jamielaird
14 - Magnetar

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

 

Screenshot 2019-04-04 at 20.49.25.png

rrahman
6 - Meteoroid

Thanks was very helpful. Thanksssss :D

Labels