Is it possible for you to split the table into two tables? With Tableau, it's a visualisation tool and it's not recommended you have so many columns in one view. We wouldn't recommend usingTableau as you would Excel where you'd have so many columns.
Try if you can fit some of the major dimensions as filters and avoid placing them in the report.
Another method is categorize the dimensions and then use the parameter capabilities to dynamically select the dimensions.
It is not good practice to have all the columns in the ataboe
Do you have to show all of the columns at one time or could you create hierarchies that would allow the user to drill down? This could make this much easier to read.
I asked this same question the first week that I worked in Tableau and some nice person on the forum told me to use Excel.
Thanks for your suggetions.
FInally i got the answer for showing 100 columns an dnow when i display 10 records , it is working fine and when i try to pull all the rows(3 lakshs) then it is throwing error "Out of memory"