View whole output of ETL actions

When building an ETL, how can I view the whole output of an action within the ETL?
After running the preview I can only view 100 rows.
Example:
1. I join two datasets (that are created within the ETL) to one without knowing if the join-columns are unique. I want to view the datasets that go into the Join action and the dataset that comes out of it to check if the number of rows before and after the join are equal.
2. I am looking for an error in an existing ETL. I want to check the outputs of the actions to find the place where calculation goes wrong for a certain row. How can I do this easily? I know I can apply a filter to the output to view the desired row but that is very laborious.
Thank you very much in advance!
Best Answer
-
Hi @user014481
Preview won't display all of the records because it's just that, a preview. If you're wanting to see data from each step you can filter the data you want and then output it to different dataset(s) along the ETL path.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers
-
Hi @user014481
Preview won't display all of the records because it's just that, a preview. If you're wanting to see data from each step you can filter the data you want and then output it to different dataset(s) along the ETL path.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 819 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 781 Automate
- 193 Apps
- 483 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 43 AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- 409 Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive