Data Source: Teradata Stored Procedure
Tableau Version: Tableau 9.3
We have a parameter 'customer id' in stored procedure so a string parameter is created in Tableau to pass multi-value manually. The connection that is used is Live Connection.
I would like to check if the user changes the parameter values for 'Customer Id' in Tableau by a comma separator, will the teradata stored procedure work?
Ex: If the user enters (C125, C129, D345, B345) in a 'Customer id' parameter, will it pass these values to the stored procedure and fetch the required data ?
Please let me know your thoughts on this.
While I don't believe you can pass parameters directly to stored procedures, you may have success in connecting using Custom SQL and passing the parameters that way. http://onlinehelp.tableau.com/current/pro/online/en-us/help.htm#customsql.html