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
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有