Recursive ETL issue - JOIN
Hello,
I am having trouble with a recursive ETL. When I update my data set "Record Status", the rows are not appending, the duplicates are not replaced and the card data doubles. I believe the error is related to my join but I cannot pin point the issue. I have read many support articles pertaining to recursive ETL's which have not solved my issue. I am hoping that someone can review my case and point me in the right direction.
Please see the enclosed image for a better understanding of my current ETL.
Thank you,
Comments
-
Hi @user066906 ,
It's likely not your join. With the changes in Magic ETL 2.0 NULLs are handled differently than in ETL 1.0. With 2.0 they are now handled the same way as SQL, as a special value.
ETL 1.0: NULL <> 'Delete' = TRUE
ETL 2.0: NULL <> 'Delete' = FALSE
This is because you must use an explicit NULL check instead of <> 'Delete'.
So on your filter tile, instead of saying <> 'Delete' change it to be 'IS NULL' instead of 'Not equal to'
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 969 Connectors
- 256 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 501 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 375 Beast Mode
- 20 Variables
- 484 Automate
- 102 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive