Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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

3 Replies
MVP
MVP

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

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

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

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

Not applicable

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

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

Community Browser