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.
Vendor_Provider:
LOAD
SWCUSTOMERID AS C_PROVIDER_ID,
SWNAME AS C_PROVIDER_NAME,
SWNOTE AS C_NOTES
;
SQL
SELECT
SWCUSTOMERID,
SWNAME,
SWNOTE
FROM GPS.SW_CUSTOMER
;
