Trouble joining tables - tables share the same fields

darren_dixon — Tue, 14 May 2013 09:57:35 GMT

Hi,

Please, please help! I am having trouble linking 3 tables together. I keep getting syn tables as all three tables share the same fields.

The tables should link like this:

Applications: Link: Applicants:

ApplicationID ApplicationID

ApplicantID Applicants

All 3 tables include the following fields:

"Int_ID"
"DB_Action"
"Session_Token"
"Audit_Date"

Applications:

Load

ApplicationID,

InputDate,

Username,

Password;

SQL Select *

From Audit.dbo."tbl_Applications";

Link:

Load

ApplicationID,

ApplicantID;

SQL Select *

From Audit.dbo."tbl_Applications";

[Applicants]:

Load

ApplicantID,

First_Name,

Last_Name,

DoB;

SQL Select *

From Audit.dbo."tbl_Applications";

Re: Trouble joining tables - tables share the same fields

Tue, 14 May 2013 13:18:08 GMT

Hey,

Qlikview automatically creates links between tables with the same fields. If you don't want this to happen you have to change the name of the fields. You can do this either manualy or use the Qualify function.

Hope this helps.

Gr.

Frank

topic Re: Trouble joining tables - tables share the same fields in QlikView

Trouble joining tables - tables share the same fields

Re: Trouble joining tables - tables share the same fields