How to change schemas dynamically in tableau.?
Below is the scenario.
I have a dashboard using below sample custom sql query.
select * from <schemanmae>.tablename;
I have different schemas with same table name and structure.
I have to change schema names based on user selection, like i have to display schema names in dashboard as a dropdown, based on schema selection , should execute custom sql query.
with custom sql, you can insert a parameter. Can you do this with inserting the schema?
i tried using that option, but not working.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...