We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Crosstab multiple specific fields

jonasebner
5 - Atom

Hello,

 

i want to crosstab multiple specific fields, which can be dynamic. 

 

At the moment it looks like this:

 

placeworkersvalid from daytime
B2012023-01-01Monday05:00
B2012023-01-01Monday223:00
B2012023-01-01Tuesday06:00
B2012023-01-01Tuesday2

20:30

...    

 

But i need it this way: 

 

placeworkersvalid from daystartend
B2012023-01-01Monday05:0023:00
B2012023-01-01Tuesday06:0020:30
...     

 

I tried it with additional columns but couldnt figure out, how to get the specific fields in the second row the be placed at the right spot. 
Is there a way to do this with alteryx? 

Thanks a lot in advance

 

 

 

 

 

 

5 REPLIES 5
Christina_H
14 - Magnetar

This works for your test data

Christina_H_0-1677599620862.png

DataNath
17 - Castor
17 - Castor

Hey @jonasebner, how does something like this look? The Formula tool generates a cleansed weekday for you to group on, as well as creating Start/End flags based on whether it's the 2nd instance of that day (contains 2). Then we use these to group on and employ as our new headers respectively:

 

DataNath_0-1677599684615.pngDataNath_1-1677599692511.png

BS_THE_ANALYST
15 - Aurora
15 - Aurora

@jonasebner One way:

BS_THE_ANALYST_1-1677601241749.png

 

 

All the best,
BS

LinkedIN

Bulien
jonasebner
5 - Atom

works perfect, thank you :) 

jonasebner
5 - Atom

This works also, thank you

Labels
Top Solution Authors