Discussion Board for collaboration related to QlikView App Development.
I have an issue with a relationship that creates a loop based on my table structure. I do not have access nor control on how the tables get created or modified. I only have an ODBC connection to the DB and this is why when I add a table that needs a relationship with other tables that currently have existing relationships I get loops. I am thinking if I can duplicate the date in my table that I need to form the relationship with thereby creating two identical tables I can form two separate relationships to get the information I need. There are only three fields in this table and below is my qlikview code to access the table. I also attached an image of the loop.
The SWCUSTOMERID is used to form the relationship with the other tables that need the Vendor information from the SW_CUSTOMER table.
SWCUSTOMERID AS C_PROVIDER_ID,
SWNAME AS C_PROVIDER_NAME,
SWNOTE AS C_NOTES
I am not sure but try this and let us know?
Concatenate Access_Circuit and Base_Circuit tables.
Rename the field [Access_ID] AS Channel_Access_ID in Challen_Port table. Do these two and run and let us know.
So something like this.
I am not sure what your trying to accomplish. Both my Base Circuit and my Access Circuit tables need to form relationships with the sw site table. I think your trying to bring those together and make a new table out of the base and access circuits. correct. If that is the case this will not work as there are other fields in those tables that are named the same and cannot overlap.
Yes, that is what i am trying to do and once they are concatenated that one single table holds the data of Base and Access table columns with their data. And where is your SW Site table I cant see in your data model?
Else just rename your Channel_Port Access_ID field to Channel_Access_ID and run it.
GM Vishwarath. I looked at your suggestion and cannot see how this will work. I am uploading additional information that may help in the solution. Let me know.