Found a Cycle exception

Help
1

I am trying to execute Merge action in dbt on my databricks. Getting
Found a cycle: model.myproj.transtoexpire → model.myproj.trans error.

I need to update certain columns in the existing record and append new record. Is there option to perform using dbt

2

By using same table under ref and source, able to perform merge without any issue. Thanks.

3

@GaneshSubramani, Can you please elaborate how you were able to resolve that issue?