3 Replies Latest reply: Sep 24, 2014 5:14 PM by Phaneendra Kunche RSS

    Load Statement Help

      I am trying to trim down my records to a specific group of names from one table. Here is what I have thus far...

       

      OBSNAME_Sort:

      Load * Inline [

      NAME

      LDL

      A1c

      BP Systolic

      BP Diastolic

      Diabetic Eye Exam

      Smoking Status

      DM Retinopathy

      Smoking Cessation

      DM Foot Exam

      ];

       

      Flowsheet:

      LOAD HDID,

          NAME;

      SQL SELECT HDID,

          NAME

      FROM xxx.xxx.FLOWSHEETLABELS;

       

       

      DROP Table OBSNAME_Sort;

       

      With this I can organize the record names with this statement but I need to condense the record names to this list alone otherwise I'm still getting hundreds of flowsheet names and values associated with those names.

       

      How do I trim the table "NAME" down to give me only the records listed above and dismiss any other record? 

       

      THANKS!