2 Replies Latest reply on Jul 30, 2018 10:26 PM by Victor Lung

    How to add new column in incremental extract?

    Victor Lung

      Dear All,

       

      I have difficulties in adding new colums in incremental extract. Would someone advise me how to do that?

       

      I have a scheduled incremental extact (use custom SQL) to append data everyday and has already stored 3 months daily data. Now, I would like to add new columns into the incremental extract while keeping the historical data. I have tried different ways, but failed to do that. Below are the original and new extracts for reference.

       

      Original Incremental Extract (3 columns)

       

      DateCustomer Label 1NO. of Customers
      2018-07-01Yes100
      2018-07-02Yes150

       

       

      New Incremental Extract (3 columns + Add 2 New Columns)

       

       

      DateCustomer Label 1Customer Label 2 (new)Customer Label 3 (new)NO. of Customers
      2018-07-01Yes100
      2018-07-02Yes150
      2018-07-03YesNoYes80
      2018-07-03YesYesNo

      90

       

      Many thanks.

       

      Regards,

      Victor