Where is my data going??
My data seems to be disappearing between the ETL and the final data that it actually outputs. Here are some pictures to try to explain what's happening. The first image shows the preview on the final tile in the workflow (being the output file titled Work Numbers (Final)). The second image shows the same chunk of data, using that same output and examining the data with "Views Explorer."
Where did my data go? Absolutely NOTHING changed between these two steps. It's driving me crazy that it's seemingly there, but then disappears, thus preventing me from being able to use it at all.
Best Answer
-
In MagicETL you are only previewing 100 rows. I see in the second image that there are 1,737 unique values for the BMI Work Number in your final output data. It appears that the data is there and that there are also null values for that field.
If I solved your problem, please select "yes" above
1
Answers
-
In MagicETL you are only previewing 100 rows. I see in the second image that there are 1,737 unique values for the BMI Work Number in your final output data. It appears that the data is there and that there are also null values for that field.
If I solved your problem, please select "yes" above
1 -
I understand that there's more data that isn't shown in the preview, but that doesn't really answer the question because I'm looking at the exact same chunk of data in both screenshots. If I filter just for the track title names that I'm showing in the preview section, it still shows all that data erased. There is nowhere in my entire data set where "TRACK TITLE: With Version" with a value of "Grits 'n Gravy" has a "BMI Work Number" of "51911889" outside of the preview. So I don't understand where it's going.
0 -
Actually I increased it to 400k and now it's showing it as null lol… I'm not really sure what's going on. I'm going to take a deeper look into the data. Sorry, looks like I don't understand how the preview works and you were probably right 😅
0
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