Seeing more rows in ETL preview
Hi all,
This is likely a basic questions, but I can't figure it out. . When I run a preview on my ETL, regardless of how many rows I chose to run it on, I can only see 100 rows. Is there a way to see more? There are anomalies that I need to be sure are accounted for in my algorithm and the preview doesn't always show these rows.
Thanks!
Best Answers
-
Unfortunately, no. The preview window will only let you scroll through 100 rows. It would be nice if it would. Next to run preview, you can change how much data it will pull in (default is 10k rows), but that still won't affect how many rows are in the preview window.
You can help your troubleshooting a little bit by dragging in some filter tiles and filtering on specific things that will force the results to show up in your preview, but it is safest to run the ETL and then view the output dataset and see if the results came out as expected.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
The 1k, 10k, 100k, etc.. are for deciding how many rows you want to include from your input datasets. This is helpful if you have some joins in your dataset and, depending on how your input dataset data is sorted, you might not see any results to your join unless you tell the preview to process a larger chunk of your dataset.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
Unfortunately, no. The preview window will only let you scroll through 100 rows. It would be nice if it would. Next to run preview, you can change how much data it will pull in (default is 10k rows), but that still won't affect how many rows are in the preview window.
You can help your troubleshooting a little bit by dragging in some filter tiles and filtering on specific things that will force the results to show up in your preview, but it is safest to run the ETL and then view the output dataset and see if the results came out as expected.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Thanks Mark! What then does limit preview rows to 1K, 10Km 20K etc. mean?
0 -
The 1k, 10k, 100k, etc.. are for deciding how many rows you want to include from your input datasets. This is helpful if you have some joins in your dataset and, depending on how your input dataset data is sorted, you might not see any results to your join unless you tell the preview to process a larger chunk of your dataset.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Gotcha. Thank you!
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
- 747 Beast Mode
- 59 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
- 396 Distribute
- 113 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