simply question
How do I delete a row of data that is incorrect. It has passed through staging and is has populate my card. I don't know how to remove it as i have no reference .
Thank you
Best Answer
-
Hi @NevilleMills, due to the underlying architecture of Domo and data storage in general, the data removal process would not be as easy for users as say, highlighting rows or columns in the DataSet level and deleting, or running a DELETE FROM type command.
What you can do is create a dataflow to input your dataset, filter out the row(s) you don't want and then direct it out to another dataset (i.e. Unused/Archived). You could also then contact Support [support.domo.com] to request for those rows to be deleted once you have directed the unwanted data into a separate dataset.
13
Answers
-
Hi @NevilleMills, due to the underlying architecture of Domo and data storage in general, the data removal process would not be as easy for users as say, highlighting rows or columns in the DataSet level and deleting, or running a DELETE FROM type command.
What you can do is create a dataflow to input your dataset, filter out the row(s) you don't want and then direct it out to another dataset (i.e. Unused/Archived). You could also then contact Support [support.domo.com] to request for those rows to be deleted once you have directed the unwanted data into a separate dataset.
13 -
Is this dataset configured with an upsert key? There may be an option with the CLI if your dataset is configured with an upsert key
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Thank you both. This has been a b g help as I start my domo journey
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 688 Automate
- 177 Apps
- 453 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 126 Manage
- 123 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive