Tableau how to get more then 16 columns

I tried following approach and it worked.
rename .twb file to .xml
(if your tableau file is twbx then rename this file to .zip . get .twb file from this zip file. )
Open in notepad

search for following text:

change ’16’ to your desired value.
Now rename the .xml back to .twb. Open in tableau.

Though you could add more columns in tableau by changing xml, UI doesn’t look good. As tableau doesn’t support scroll bar on “Rows”

source:
https://community.tableau.com/thread/238456

Tableau tabcmd *** Uncaught exception RuntimeException: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.securi ty.provider.certpath.SunCertPathBuilderException: unable to find valid certifica tion path to requested target

Tableau tabcmd error
tabcmd login -s https://tableauserver.com -t site1 -u username –p password

*** Uncaught exception RuntimeException: javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: PKIX path building failed: sun.securi
ty.provider.certpath.SunCertPathBuilderException: unable to find valid certifica
tion path to requested target

When you get this error there are 2 ways of solving:
Solution1: Add tableau weburl to your trusted url’s in IE.
Solution2:
add –no-certcheck
tabcmd login -s https://tableauserver.com -t site1 -u username –p password –no-certcheck
and append –no-certcheck to export commands as well.

How to get SQL from Tableau

Follow below steps:

select Help → Settings and Performance → Start Performance Recordingfrom the Tableau toolbar.

Then right click on the source in the Data toolbar and select ‘Refresh’. This will force Tableau to re-run the query.

Once the query completes, select Help → Settings and Performance → Stop Performance Recording from the Tableau toolbar.

This should result in a new Tableau window opening with a workbook called ‘Tableau — PerformanceRecording’

Right-click anywhere in the bar next to ‘Executing Query’ and select ‘View data’

Source of the article:
Below URL gives a very good idea about this
https://blog.openbridge.com/7-steps-to-export-sql-statements-from-tableau-7e51a2fd4277

Tableau how to remove ‘abc’

2 approaches-

Approach1#
1. select abc
2. go to color and change opacity from 100% to 0%. this would hide text ‘abc’
3. now right click on column next to abc, go to format-> Column Divider-> pane-> none
4. now reduce the size of abc column as minimal as possible. so user wont be able to see it.

Approach2#

Create a new blank column with text ‘ ‘. Drag this column and repeat above steps – 3,4.

Detailed video is also available at youtube.