Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello together,
i have the table
"tablerelation"
RECID | TABLE1 | RECID_1 | TABLE2 | RECID_2 |
1 | ADDRESS | 24 | SALES | 3 |
2 | SALES | 1 | CUSTOMER | 4 |
3 | CUSTOMER | 55 | ADDRESS | 22 |
4 | ADDRESS | 23 | ADDRESS | 29 |
5 | CUSTOMER | 4 | ADDRESS | 101 |
, witch describes how the links between the tabels are
That meens:
The row 24 in the table ADDRESS is related with the row 3 of the table SALES
The row 1 in the tabel SALES is related with the row 4 of the table CUSTOMER
Attention:
The row 23 of ADDRESS is related with the row 29 of ADDRESS
in This case i have 2 relations from one table to another table.
Qlik don´t allow 2 parallel relations between tables. Qlik generate an syntetic index.
How to solve the problem, the to tabels are realated with more then one link?
Thanks to all.
Frank
can you post some sample data for all 3 tables?