1 Reply Latest reply on Apr 2, 2018 2:30 PM by Patrick A Van Der Hyde

    Incremental refresh add new columns

    Lavina Tang

      Hi,

       

      I connected Tableau desktop to the MS SQL database and used custom SQL query to select the columns that I wanted.

       

      Select productname, price, ratings, periodDate from products

       

       

      I then created an extract that is incrementally refreshed by periodDate.

       

      Now I want to add one more column to my data called periodID.

       

      If I rewrite my custom SQL, it will mess up with my incremental refreshed data - only the updated data in the database shows but not the previous data that I had stored in the extract.

       

      If I create a join (new table with the new column joins the old table with all historical data), the combined table gets fully refreshed and all my old data are gone again.

       

      Is there a way that I can tackle this?

       

      * I am using only tableau desktop at this point.

       

      Thanks in advance!