I've enountered an odd error in Tableau while accessing a SmartSheet via the Live Data Connector.
In Tableau, I'm attempting to concatenate a SmartSheet string field with a string contant:
* [Primary Column] + "A" (where Primary Column is defined to be a string).
When I do this accessing the data with the SmartSheet Live Data Connector, Tableau issues an error in the caluculated field editor, "Can't add string and string values".
When I do this accessing the data via an excel spreadsheet created by exporting the SmartSheet sheet, then everyting works fine.
Any ideas why I'm having these issues?
Thanks.