Forum Discussion
Merge queries has caused a cyclic reference
Below is a simplified example of my issue.
Lets say I have 7 tables, named table 1, table 2, table 3 etc...
Table 1 needs to use a column from the last 5 tables before it which would be 7,6,5,4,3 so I merged these 5 tables into table 1 and filtered to the column i need from each of those tables.
Table 2 i did the same except it looks at 1,7,6,5,4 so merged
Table 3 merged 2,1,7,6,5 (here I hit a cyclic reference, I am assuming because table 3 merged with table 1 and table 1 is merged with 3)
Is there a way when I merge table 3 with table 1 to not evalutate itself or ignore that column in table 1 that is merged from table 3.
Sorry I hope I've explained that clear enough!
Thanks in advance for any tips
2 Replies
stug yes that's is the case why you are getting cyclic, may be make a copy of table 3, have that copy relationship with table 1 and then regular table 3 can have relationship with table 1.
although it is bit odd that are refereing these tables back and forth but I guess you know what you are doing.
Would appreciate Kudos 🙂 if my solution helped.
Have created a formula in the table having no relation or formula using the cross filter. and then try to again use them in a formula where that relation no there, then it might give such error.
