How to Unpivot (Transpose) in Tableau Prep

Thanks for checking out this video! To learn more, check out our upcoming classes, webinars and office hours here: www.eventbrite.com/o/onenumbe...
------
Tableau Prep is a rapidly evolving tool. Old methods of transposing values in Tableau Prep are already outdated! With the inclusion of the new Rank function in Tableau Prep calculations, it’s no longer necessary to create a pivot field outside of Tableau Prep. This is great news because it means every step in transposing your data can now be done in Tableau Prep! Check out the video below to learn how.

[@onenumbertableau]

Need help transposing data in Tableau Prep? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909
Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163

[@alichouaki7135]

very useful video, thank you very much! If we had wanted to transpose the dates too, to have the columns date job 1, date job 2 and date job 3. How would you have done it? on the same pivot?

[@onenumbertableau]

You're welcome! I think I'd create a separate branch and pivot step for the dates. Then you can pivot the dates in a similar fashion and join them back on the employee id. Does that work?

[@alichouaki7135]

Thank you very much ! I did it in the same branche, I added one transpose before the aggregation. Then i aggregated all the columns at once !

[@alichouaki7135]

your video helped me a lot, thank you again! I sent you an invitation on linkedin

[@akshayasundar5435]

This is great! I'm trying to achieve something like this but after this step, I want the user to be able to filter on the employee ID (in this case) and see only those columns. Can this be done through Tableau desktop?

[@onenumbertableau]

Thank you! Are you thinking of something like Row-Level Permissions? onenumber.biz/blog-1/2018/11/20/setting-up-row-level-permissions-in-tableau

[@akshayasundar5435]

@@onenumbertableau Thank you for your response! This is what I'm trying to achieve -
Employee ID Employee Name Title Department
1 John Data Analyst Analytics
2 Mike Manager Production
3 Taylor Systems Engineer. Production
4 Ron Data Engineer Analytics
5 John Director Sales
Filter on Employee Name: Ex. John
Output Visualization:

Employee #1 Employee #2
Employee ID 1 2
Employee Name John John
Title Data Analyst. Director
Department Analytics Sales

[@onenumbertableau]

@@akshayasundar5435 I've never really seen anything done like this in Tableau desktop. I guess you could use a Parameter to swap the column reference? (Like this: onenumber.biz/blog-1/2022/3/1/how-to-swap-a-field-with-a-tableau-parameter).
What is your use case? Why are you structuring your data like this?