-
1. Re: Combining Values in Multiple Fields
Mahfooj Khan Apr 12, 2016 5:00 AM (in response to Dzulhazmi Sha'arin)You have to transpose the fields Program Attended 1, Program Attended 2, Program Attended 3, Program Attended 4, Program Attended 5. See the workbook(version 9.2)
Feel free to ask if you've any query.
Mahfooj
-
Comp.twbx 15.0 KB
-
-
2. Re: Combining Values in Multiple Fields
Margarita Rodriguez Jul 19, 2016 11:05 PM (in response to Mahfooj Khan)How did you transpose the fields. Did you do it in Excel?
-
3. Re: Combining Values in Multiple Fields
Mahfooj Khan Jul 20, 2016 1:06 AM (in response to Margarita Rodriguez)Once you connect your data in tableau. In the data source grid pane your can select your fields and right click and select pivot. Go through the link for more detail about pivot in tableau. If this answer your question then close the thread so that It may help others. This thread is opened since last three months so try to close it.
Pivot Data (from Columns to Rows)
Mahfooj
-
4. Re: Combining Values in Multiple Fields
Margarita Rodriguez Jul 20, 2016 7:41 AM (in response to Mahfooj Khan) -
5. Re: Combining Values in Multiple Fields
Chris Dickson Jul 20, 2016 8:12 AM (in response to Margarita Rodriguez)Hi Margarita,
what version of Tableau are you using and what is your datasource?
If you are using Tableau version prior to 9.0 or you are connecting to a database source then the pivot option will not be available.
The pivot option is only available to file based sources, e.g. txt, csv or excel.
-
6. Re: Combining Values in Multiple Fields
Mahfooj Khan Jul 20, 2016 8:10 AM (in response to Margarita Rodriguez)Are you using Legacy connection? Take a look first whether its "Connected to Excel (Legacy)". If so then re-create your connection and be sure not to select the legacy option and you should be able to pivot fine.
Differences between Legacy and Default Excel and Text File Connections | Tableau Software
-
7. Re: Combining Values in Multiple Fields
Margarita Rodriguez Jul 20, 2016 9:34 AM (in response to Mahfooj Khan)I was trying to do it with a server connection. Looks like it's only available for excel. Thanks!
-
8. Re: Combining Values in Multiple Fields
Mahfooj Khan Jul 20, 2016 9:59 AM (in response to Margarita Rodriguez)Yeah pivot option is only for excel and text files.