ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Cross Tab

hj121479
6 - Meteoroid

As an example, I have this data -

 

hj121479_0-1620168355267.png

Trying to group by the name

 

hj121479_1-1620168391551.png

 

 

Could you please help how I can group the alert numbers by name? 

apathetichell
13 - Pulsar

If this isn't what you are going for can you explain what you how something fits into alert 1 vs alert 2.

hellyars
12 - Quasar

This works.  I had not seen @apathetichell solution posted when I started.  I was too slow, but it looks like we used slightly different approach.  

 

UPDATE:  Note, I switched Alert from a byte to a string to use the Sum tool.  I switch Alert back to a byte in the last Select tool.  

 

Screen Shot 2021-05-04 at 7.01.51 PM.png

hj121479
6 - Meteoroid

Thank you so much!

Labels