I am not sure if Tableau can be able to have more than 10 columns? I did something similar, but after 6-7 columns, the data start to merge together each time I add another columns. Does Tableau have the functionality to create over 10+ columns table? I used to use BO or write SQL, but I was thinking if I can use Tableau to substitute the other 2 platform. Please advice.
The number of columns in your view can be changed by going to Worksheet-->Table Layout-->Advanced. Then, change the number of Maximum levels of column labels. The most it allows is 16. I hope this helps!