This content has been marked as final.
Show 2 replies
-
1. Re: aggregating comma separated values
sami.amjad Oct 23, 2017 10:25 PM (in response to Mrinal S)Perhaps you could try to do a Split on the Sale Agents column in the Data Source, which will give you each of the agents in separate columns.
Then to be able to do aggregations of the different sales agents, you would want to Pivot the columns into rows - look into using Tableau Pivot().
Hope this helps
-
2. Re: aggregating comma separated values
Galen Busch Oct 23, 2017 10:25 PM (in response to Mrinal S)Hi Mrinal,
In the data connection pane, you can 'Split' this column at the commas if you aren't able to connect to this file as a CSV.