Hi,
I have created a model for query studio in which i have a requirement like below..
I have 5 tables table1,table2,table3,tabble4,table5
i have created a standalone filter from table3 query item (table3.acctno),
the acctno is present in table4 also
whenever i pull any column from table4 along with standalone filter(from table3) it creates a join with table3
As per the requirement we need to use the filter which should be dynamic to choose the acctno from the table which it has been pulled (for ex if i pull the acctno from table2 then the filter should from table2)