Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Celia,
You should try command Qualify *;
After you can manage your keys by Unqualify command.