All the string parameters are sanitized to make them string literals which will invalidate SQL statement.
In case of Oracle you'd get this and which will fail with "ORA-00903: invalid table name"
SELECT * FROM ( SELECT A, B FROM N'"My_table_from_parameter"' ) "TableauSQL"
Do i have a work around for this? not only in tableau or any other way ..
My requirement is simple. I just need to select data based on parameter selected by user. in any visualization format.
How about creating view in Oracle where you UNION all tables, add additional column with table name in it and then filter on that column via parameter?
There is so much of data, and to create a view would involve approvals stuffwhich is tedious. DO we have any other alternative.