Alteryx Designer Desktop Discussions

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

Cross tab 2 columns

natalia_flood
6 - Meteoroid

Hello everyone,

I am quite stuck in one parte of my flow and I need help! Please!

This is the out put of the formula tool of my flow attached (inside the red circle).

StatusClosedNot ClosedTotal 
Keep43271228
Move10190180

I am trying to rearrange the data to be like this:

StatusTotal
Keep228
Move180
Closed223 (Total of column)
Not Closed461 (Total of column)

I want to cross tab just the columns Closed and not closed, but isn't work. 

Help!!!

3 REPLIES 3
messi007
15 - Aurora
15 - Aurora

@natalia_flood,

 

Please see below:

 

messi007_0-1611147364052.png

Hope that helps!

Attached the workflow.

Regards,

natalia_flood
6 - Meteoroid

Amazing! it was so quick! Thank you so much @messi007 

messi007
15 - Aurora
15 - Aurora

@natalia_flood,

 

Happy to help 🙂

 

Regards,

Labels