Oh no! The Community appears to be haunted! Help us find all the spooky specters here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
14 - Magnetar

@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
14 - Magnetar

@natalia_flood,

 

Happy to help 🙂

 

Regards,

Labels