Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Pivot equivalent

Highlighted
5 - Atom

Hey all,

 

I am currently trying to pivot a bit of data from this;

Cust noChannel
1234Store
123456Web
123456Web
123456Web
123456Web
123456Web
123456789Web
123456789Store
123456789Store
123456789Web
123456789Store
123456789Store
123456789Store

 

to this;

Cust NoStore CountWeb CountShop by
123410Store
12345605Web
12345678952Both

 

The 'Shop by' column, I believe would be an IF function, on the lines of IF [store count] and [web count] >=1 then "Both"

 

Apologies if it's already been done, can't seem to adopt any of the ones answered to my flow.

 

Thanks in advance! 

Highlighted
Alteryx
Alteryx

Here you go! Just a summarize and then a crosstab. Workflow is attached. 

 

pivot.png

Highlighted
5 - Atom

Hi Brandon,

 

Thank you for such a quick reply and the solution  - you made that look faaar to easy!!! 

 

Is there any chance you can show us how to do the formula to highlight if they've shopped just in store, online, or in both? I hope that makes sense. 

 

Many thanks,

 

Lois. 

Highlighted
Alteryx
Alteryx

Here you go! Updated workflow is attached. 

 

pivot v2.png

Highlighted
5 - Atom

Thank you so much, you're a life saver!!  

Labels