Alternative way to solve cyclic dependencies error between tables in Spotfire
I'm trying to figure out a way to resolve cyclic dependencies error between tables in spotfire.
Exact Problem : (Screenshot and .dxp attached)
I have two data sets - Cust1 and Cust2. Both tables have CustomerID and City columns. I have two more tables with only one column each - CustIDFIlter (CustomerID column) and CityFilter (City column) - I want to use these two tables to filter on Cust1 and Cust2 at same time.
To achieve this, I'm creating a relation between (Cust1.CustomerID and CustIDFIlter.CustomerID ) and then between (Cust1.City and CityFilter.City). And then I'm creating a relation between (Cust2.CustomerID and CustIDFIlter.CustomerID ) and then between (Cust2.City and CityFilter.City) but as soon as I'm making relation between (Cust2.City and CityFilter.City) - It's throwing cyclic dependencies error. (Below is Screenshot of error)
I've searched for this error and found this link - https://support.tibco.com/s/article/Warning-message-The-relation-could-n...
It says that we need to create a copy table if this error occurs but if I try this in my case then I'll not be able to filter using CustIDFIlter.CustomerID and CityFilter.City columns (present in text area) on both Cust1 and Cust2 tables (Refer to attached .dxp file).
EDIT: This is just the sample data set. Cust1 and Cust2 can contain completely different columns and data as well.
Can anyone help me out in achieving this. Thanks in advance :)