2 Fields in table A linking to 1 field in table B

[#1]

Hello,

How can I achieve this?

I have 2 fields in Table A:

Specialty_code_start as specialty_code

Specialty_code_end

and 1 field in Table B:

specialty_code

specialty_desc

specialty_local

How can I get Specialty_code_end to link to the same Table B?

Thank you

[jonathandienst]

Hi

The fields link when they have the same name. You could do this..

TableB:

LOAD specialty_code As specialty_code_end

     specialty_desc

     specialty_local

From .....

Hope that helps

Jonathan

[#3]

Thank you for that although it may get a bit messy as there are 5 different specialties fields in one of the tables.

Thanks Jonathan

[#4]

Hi Jonathan,

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?

TableB:

LOAD specialty_code As specialty_code_end

     specialty_desc As specialty_descB

     specialty_local As specialty_localB

From .....

Thank you