In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.
SOLVED

Transposing data - help!

madalinajones
5 - Atom

Hello! 

 

I have a bit of an issue with transposing a table. I am definitely missing a step before the crosstab tool, but I can't figure out what that is exactly. Here is my input: 

 

Record IDAction_Date
ABC1/2/2023
ABC1/10/2023
DEF1/2/2023
DEF1/5/2023
DEF1/25/2023
GHI1/3/2023
GHI1/10/2023
GHI1/20/2023
GHI1/29/2023

 

And here is how the output should look like: 

 

Record IDAction_Date1Action_Date2Action_Date3Action_Date4
ABC1/2/20231/10/2023NULLNULL
DEF1/2/20231/5/20231/25/2023NULL
GHI1/3/20231/10/20231/20/20231/29/2023

 

Any help would be greatly appreciated! 

3 REPLIES 3
MilindG
12 - Quasar

@madalinajones I have attached an example and see if that works for you.

madalinajones1
5 - Atom

Could you repost? I don't see it. Thanks!

MilindG
12 - Quasar

@madalinajones @madalinajones1 Okay I have added the attachment again