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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 803 Beast Mode
- 79 App Studio
- 44 Variables
- 758 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 73 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive