7 Replies Latest reply on May 23, 2018 8:48 AM by PJ S

    cross join between data extract and live connection

    neera gupta

      Hello,

       

      I have a heavy data extract that is scheduled to refresh every day and I want to join to a live SQL server table on Identity column. How do you do it?

       

      I tried publishing data connection to Tableau server that can be refreshed daily, then add a connection to Tableau server published data source and add then add SQL live connection. But its not supported.

       

      Has anybody else run into this scenario?

       

      I cannot have cross join and live connection between 2 data source because one of the connection takes 45 min to refresh. My solution is to have 1 extracted data and another live connection if only I can make Cross JOIN work

       

      Thanks,

       

      Raj