As I am new to Tableau prep and also couldn't find the answer after searching in the forum, I am writing this.
I am trying to pivot a excel cross tab which has holiday info about the resources from 01.01.2018 - 31.12.2018. Below shows a sample of how the data looks like:
|lfd. Nr||Resource||01. Jan||02. Jan||03. Jan||04. Jan||05. Jan||06. Jan||07. Jan||08. Jan||09. Jan||10. Jan||11. Jan||12. Jan||13. Jan||14. Jan||15. Jan||16. Jan||17. Jan||18. Jan|
I want to pivot this table so that I can join this on resource to another table where I have planned project for the resources.
I know, I can multiselect all the fields by clicking ctrl+shift+rightarrow in tableau desktop and pivot it and join it with the other table.
Since,I have data cleaning to do, I would like to know how can I multi select all the dates fields to pivot in Tableau Prep. Because in Prep, for pivoting, I could only do ctrl+mouse click to select one field, but doing this for 365 days?? There should be easier way that I would like to know.
If anyone could help me with this, would be great !!
Sorry to answer my own questions. I found the answer for this questions. You should just shift+mouse click until the fields you want to select does the multiselect in Tableau data prep.