Group By function appears to have broken in the ETL UI (but not the actual processing of saved ETLs)
I set up some ETLs a bit over a week ago that utilise the group by function to mind the max(_LAST_BATCH_DATE_) and then join that back up to allow me to filter for only the most recent version of the record.
Since then:
- the ETL was still running correctly and putting data through as expected
- opening the ETL shows the Group By node as broken (even though its specified correctly)...first picture
- I've tried fresh ETLs with simple Group By nodes....but they're broken there as well
It appears to be a UI bug:
- Create Group By node
- specify the node properly
- click on the aggregation and you get the full list of applicable aggregation methods
- click off the node (anywhere that causes the node to lose focus)
- click back on the aggregation method
- get the message 'No matches found'
This kind of stuff is making me consider making the decision to churn the company to another platform. What should have been a 5 minute task to build-it-just-like-the-other-10-dataflows-that-are-working, as is often the case with Domo, has wasted well over an hour of mine and my teams time.
Comments
-
Let's see if any of these help:
1 - Have you used the Maximum function with a Date/Time field before? I wonder if it only works on numbers. (I assume you have - just throwing it out there.)
2 - When you run a preview, are you seeing the relevant fields populating in the append query? In particular, make sure that "_BATCH_LAST_RUN_" is carrying through properly.
3 - I notice that in your final screenshot, "Add Column" is greyed out. That is strange. I would delete the transform and do it again, but I am sure you already tried that.
If none of these pertain, would you mind providing your field names and sample values?
Best of luck!
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 526 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 440 Beast Mode
- 23 Variables
- 514 Automate
- 115 Apps
- 391 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 67 Manage
- 67 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive