Deleting duplicate records only for a certain date range

Hello,

 

I've pulled all my required Data from Bigquery into Domo. During the entire pull, there were two windows where the data was doubled and tripled. How should i delete the duplicate records for that time period?

 

Table : Geo performance historical

Date ranges : 07/26/2016 - 07/31/2016 - Data has been tripled

                       01/01/2016 - 01/15/2016 - Data has been doubled.

 

Thank you!

 

Comments

  • You could use an ETL:

    1.png

     

     

     

     


    ______________________________________________________________________________________________
    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
    ______________________________________________________________________________________________
This discussion has been closed.