Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cseward1963
Contributor

a link table to connect 2 tables that are causing a loop

Hello All.  This might not be do-able, but I'm asking anyway.  Hope it's not too much to ask.

I’ve attached an excel spreadsheet that shows the layout of my tables.  The problem is that I can’t join “Dcstudents” table because it has same fields as in “CPCFile” and “Mcalendar” (I get a loop).  I need “Dcstudents” to be separated because the disciplineid in the table combines 2 disciplines (so that a student is only counted once). Example, “CPCFile” can have disciplineid 67 and 65, but in “Dcstudents”, I only have 65 (if a student received 67 and 65, the 67 is counted as 65 so that student is counted once if she received 65 and 67).    I need to still somehow connect “CPCFile” and “Dcstudents” because I need to do comparisons in the APP.  Can anyone show me how to build some kind of Link table between “CPCFile” and “Dcstudents” and a Link table between “Dcstudents” and “Mcalendar” (for the Date)?   “CPCFile” and “Dcstudents” need to use the same calendar values, etc.

Thanks in advance

Celia

2 Replies
chooco_co
Valued Contributor

Re: a link table to connect 2 tables that are causing a loop

Hi Celia,

Looks like your fact table is CPCFile and Dcstudents.

My suggestion is to concate two table into 1 table

so Your script will be like this:

Load

Disciplineid as disciplineid,
schoolid,
studentid,
therapistid,
Date,
consult,
direct,
individual,
rate,
DC

From CPC File;

concatenate

Load

 

studentid,
disciplineid,
schoolid,

Date

From Dcstudents

Regards,

Marco

gladi-cz
Contributor

Re: a link table to connect 2 tables that are causing a loop

Hi Celia,

You should try command Qualify *;

After you can manage your keys by Unqualify command.

Community Browser