How to Pivot Data in Alteryx

[HannahSwain]

Hi all,

I am having trouble with pivoting data in excel. I have two data sets- one which shows daily vacation per individual and another that shows working hours per day. I am trying to combine the data so there is a row per day per individual (which shows both vacation and working hours). Is this possible please?

Thank you in advance,

Hannah

[CharlieS]

The tools in the Transform tool category will be most useful to replicate Pivot functionality. If you can share an example file with the input tables and desired output, I'm sure the Community could put together working examples for you in Designer. 

[HannahSwain]

Thank you Charlie. Please find attached sample data.

Thanks,

Hannah

[kelsey_kincaid]

Hi @HannahSwain ,

I attached an example - the join tools on the purple tab are especially helpful for combining data like this. Let me know if you have any questions.

[HannahSwain]

Hi @kelsey_kincaid,

Thank you so much for sharing this. Unfortunately I am unable to open this as you have a newer version of Alteryx than me (I am currently on Alteryx Designer x64). Is there anyway you can save this as an older version?

Thanks again,

Hannah

[ChrisTX]

See attached file: Adjusting Alteryx files for different versions.docx

[kelsey_kincaid · Accepted solution]

Hi @HannahSwain , I added a screenshot of the workflow below if that helps. Otherwise I'd recommend following @ChrisTX 's instructions.