Add Hints to Deduplicate Tile

When I ingest the customer table from our POS, for example, and compare individual customer records to the last ingestion, I want to keep the older of the two records if selected fields show the records to be duplicates otherwise. The Deduplicate tile is the obvious choice to use, but appears to choose at random which record to keep and so won't work for me. I would like to add a section to the tile for hints, so you select a field (like _BATCH_LAST_RUN_) or a formula, and then indicate that you want to keep the record with the newest/greatest or oldest/least hint value.
As an aside, I know I can simulate this with the Rank & Window tile by putting the fields that I evaluate for duplication in the Window section, sorting on the date field, and filtering on the row number, but that's a workaround, and it feels more expensive to use than the Deduplicate tile (I could be wrong about that, though). My suggestion would make the Deduplicate tile usable for more than just simple use cases.
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 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
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive