Our company has embarked on using QLIK. I am in the training phase and have been working through a book reading, while using my data for building an application.
SELECT
a.PatientID
, a.MRN
, a.CurrentActiveDTS AS CareManagementDTS
, b.LastUpdateDTS AS PayorLastUpdateDTS
, a.CurrentActiveFLG as CurrentMember
FROM
Work.CareManagementPatients a
INNER JOIN
Work.NextGenRoster b on a.PatientID = b.PatientID
--result 512 rows. (which I got)
SELECT
a.PatientID
, a.MRN
, a.CurrentActiveDTS AS CareManagementDTS
, b.LastUpdateDTS AS PayorLastUpdateDTS
, a.CurrentActiveFLG as CurrentMember
FROM
Work.CareManagementPatients a
INNER JOIN
Work.NextGenRoster b on a.PatientID = b.PatientID
WHERE
a.CurrentActiveFLG = b.ActivePayorFLG and a.CurrentActiveFLG=1
(which I can't) -- result is 191
ISSUE: I was using the "one table" method and trying to join them, which I did. Then, I figured the formula for adding. Then, I was using "set analysis" and that worked. However, I wanted to JOIN IE perhaps, link and I did finally. The issue in the "LINKTable" is the fact my data in PREVIEW is not showing. How to load a table, update that table with other values?
Any help is greatly appreciated in advance.
Thanks for the time and attention in this matter in advance.
Figured it out using the "INNER JOIN". What if, this table is in memory. Then, the other is in memory. Then you want to create an "INNER JOIN" - linktable. How does one get data in where they both have a match?
I knew that I could use the inner join. What if, one .loads one table per script. That means the tables are in memory. How does one create the "inner join" at that point? Or can it be done?
