In this case the best thing will probably be setting up an ETL process pre-tableau that does this for you. You might be able to use the split function and then pivot the data but realistically this is best done from ETL wherein you would have a data set that said.
Shasta Palo Alot,
Amadeus San Francisco
This will allow you to show the city for each based on the Name. If you plan on using a map I'd recommend bringing in a country field as well. Because there are several Londons in the world and it would be better to have these plot automatically instead of you having to tell it to use London, UK instead of Canada or the US.
Yeah agree with Carl. If you're planning for long term then try to transpose your city column into rows at database level as Carl has shown in his reply then connect with tableau. Else If its a one time activity then you can use spit and pivot option in tableau. Before connecting with tableau make sure you've correct naming convention of your geo locations. Try to add some higher level hierarchy details into your data like State/Province for better result.
1 of 1 people found this helpful
Actually you can spilt but can not pivot
For pivot you've to copy this data and paste in a new excel workbook and delete the main column of Geo Activities. Your final data will be like this
Now connect this data in tableau. You will get pivot option.
After pivot you'll have this
Then change the geo role of pivot field value. So that you can use it in map.
Hope this help.
It could be in idea.
It would be useful trsnspose splitted fields.
I am not sure if this will help you guys but this problem very much resembles to this workbook. This workbook is downloaded from Brosnon Shownk's Tableau public profile.
See if it helps. (In this case solution is the challenge and challenge is the solution. Let's see if we can reverse this thing). I am not sure. Please help if it is possible.
Let me know if this can be achieved by reversing this stuff.
Thanks and Regards,