3 Replies Latest reply: Sep 23, 2013 1:03 PM by A B RSS

    Adding a flag in a script

      Hi,

       

      I have a Patients table and Clinique Visits table.

      Not all patients have visits records.

      I’d like to add a flag to the Patients table

      That represents when no visits exists for the relevant patients.

       

      The following left join doesn’t work.

       

      Left Join (Patients)

      LOAD

      PatientID,
      'No'
      as WithClnVisits

      Resident [Clinique Visits]
      Where not Exists (PatientID);

       

      Any idea why?

       

      Thanks!