Found a Cycle exception

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

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