Recursive ETL issue - JOIN
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.