3 Replies Latest reply on Aug 26, 2016 8:02 AM by Tom W

    Using Filter & Custom SQL to select table from datasource

    siyang.teo

      A continuation of my previous post (Which is better? Union tables from same data source into one or keeping separate when using a filter ):

       

      I have a few tables of a few million rows from the same datasource, and same fields.

       

      Union them together will create too huge a table, and Tableau takes forever to load a simple viz.

       

      Since each table structure is identical, is there any way I can create a filter parameter such that when selected, will change the table source (via e.g. a custom SQL)?

       

      Will appreciate if someone can offer a sample if its not too hard.

       

      Or any alternatives to overcome this.

       

      Thanks!