I am now recieving this message:
- One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. QlikView will cut the loop(s) by setting one or more tables as loosely coupled. Settings for loosely coupled tables can be modified after script execution in the tables page of the document properties dialog.
Using your example, would it be better to do the following or let QlikView sort it out automatically?
LOAD specialty_code As specialty_code_end
specialty_desc As specialty_descB
specialty_local As specialty_localB