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:
0
This discussion has been closed.
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 664 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 824 Beast Mode
- Visualize
- 2.6K Charting
- 87 App Studio
- 46 Variables
- Automate
- 195 Apps
- 486 APIs & Domo Developer
- 91 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 119 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive