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!
0
Comments
-
You could use an ETL:
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
This discussion has been closed.
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 178 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive