# How to apply a transformation until no change is made?

**URL:** <https://matillioncommunity.discourse.group/t/how-to-apply-a-transformation-until-no-change-is-made/2293>\
**Category:** Matillion ETL\
**Created:** [September 20, 2023, 3:00pm UTC](https://matillioncommunity.discourse.group/t/how-to-apply-a-transformation-until-no-change-is-made/2293 "2023-09-20T15:00:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bobec](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/bobec/32/50_2.png) [@Bobec](https://matillioncommunity.discourse.group/u/Bobec)\
**Post date:** [September 20, 2023, 3:00pm UTC](https://matillioncommunity.discourse.group/t/how-to-apply-a-transformation-until-no-change-is-made/2293/1 "2023-09-20T15:00:29Z")

</div>

I have a table in Snowflake that is joined with another one. Then it is updated based on some column that is brought through the joining.

Now, this operation should be done until no change is made to the initial table.

&nbsp;

Is there an elegant way to do so in Matillion?

Thank you for your help!

---

<div class="post-metadata">

**Author:** ![Phil\_BMatillionSalesEngineer](https://avatars.discourse-cdn.com/v4/letter/p/eb8c5e/32.png) [@Phil\_BMatillionSalesEngineer](https://matillioncommunity.discourse.group/u/Phil_BMatillionSalesEngineer)\
**Post date:** [September 27, 2023, 9:15am UTC](https://matillioncommunity.discourse.group/t/how-to-apply-a-transformation-until-no-change-is-made/2293/2 "2023-09-27T09:15:40Z")

</div>

I've not completely thought this through. But I think it'd involve using the "Export" tab from the update component, to record the number of rows updated. Then using that value in an "if" component in the orchestration job, to decide if the job should "end success" or loop around. You might also be able to do the same sort of thing using the loop iterator, by updating the variable it uses.