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
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 474 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 214 Visualize
- 259 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive