Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pgriesbach
Contributor
Contributor

2 tables with 2 common dimensions

Hello

How do load the script for these 2 tables to avoid synthetic keys.  I have tried adding a month table, a provider table and a measure table.  I keep getting this error; One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. Loop(s) will be cut by setting one or more tables as loosely coupled.

this is my first request for help..I'm stuck, please advise.

I have 2 tables - first table

month provider

201808  provider01

201809 provider02

second table

201808 provider01 measure01

201809 provider01 measure02

I also want to have a way to use a monthyear like aug 2018 that pulls data from both tables for the monthyear selected.

 

 

 

 

 

1 Reply
Claudiu_Anghelescu
Specialist
Specialist

Table1:

month provider

201808 provider01

201809 provider02

 

Table2:

month  provider_t2 measure

201808 provider01 measure01

201809 provider01 measure02

 

Changing the header un the Table2 you don't have the synthetic key.

To help community find solutions, please don't forget to mark as correct.