This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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.