Exporting a filtered file
Hi,
I recently joined multiple data sources together and we are going through and sifting through the data flow. Almost everything looks good except 5-6 columns have nulls when we are expecting data. For example we have 109,000 thousand rows and all 109k have loan IDs in them but there are only 105k rows with purchase dates in them.
What I'm trying to do to make this easier is to export an excel file where I am only looking at the purchase dates that are null and all of the other information that goes with them.
Is this possible to export a filtered excel file without going into my ETL and filtering and un-filtering for each column that is incorrect?
If this helps, feel free to agree, accept or awesome it!
Comments
-
Hi Damen,
I think that using Views Explorer on your dataset would make this a very easy lift. Once you're in there, click on the 3 vertical dots at the top of the purchase date column and select "Remap nulls"...put in a value like "rows to inspect" or whatever. Then you can filter just on those column and export to CSV. (repeat as needed for any other columns of interest)
2 -
@billobi
Thank you! That is much easier than how we were previously doing it. Much appreciated!
If this helps, feel free to agree, accept or awesome it!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 621 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 743 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive