This is implemented in v8 coming sometime soon.
+1 for me. would like to see this feature in V8!
now that v8 has been released - is there a video or doc describing how to use it?
This is awesome. I've just been playing with it. Now I can use entire workbooks as templates.
I was disappointed to see this note:
"Parameters can only replace literal values. They cannot replace expressions or identifiers such as table names."
I have a need for parameter-based table names. Oh well!
My example above suggests somewhat otherwise?
Maybe it works for table names with Text Files? It does not, however, work for a Teradata connection. I'm given no opportunity to input a Parameter value, and despite setting a default "Current Value" when creating the parameter, I receive this error:
[Teradata][ODBC Teradata Driver][Teradata Database] Syntax error, expected something like an 'EXCEPT' keyword or an 'UNION' keyword or a 'MINUS' keyword between the word 'camp_stage_' and '<'.
We've found that we are able to parameterize table names, like so:
select foo from schema_name.<table name parameter>
Works with Vertica, at any rate. Have not tried <schema and table parameter>, but kinda wouldn't want that to work, since it feels 'vulnerable.'
That sounds pretty powerful, i have a problem though (using tableau for a couple of days only...)
It seems only one value (i assume the first) passes through the parameter. Is there a way to make the full list of values going through and return the corresponding metadata from the second data connection, based on what the user clickedon, filtered, selected etc... from the first data connection?
e.g. a first query shows 100 points on a map, corresponding to companies locations. I would like the second query, which retrieves the number of employees from another table to receive the parameter corresponding to the point the user is clicking on.
Tableau does let you filter using the Data Source Filter, you just can't use Tableau parameters to the condition
so, i cant use parameters from query one to retrieve data from query 2 and send back the results to my viz?
Is it possible though to use the custom query that way :
.... where company IN <Parameters.Company_param>
(in instead of =)