How to Pivot Data in Alteryx

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

Workflow

Datasets

Reporting

Tips and Tricks

Fuzzy Match

Join

Accepted answers

kelsey_kincaid

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

All comments

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

Alteryx Test Data.xlsx

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.

Hrs Worked Vacation Example.yxzp

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703