3 Replies Latest reply: Jul 10, 2017 4:18 PM by Ruben Marin RSS

    if a cell is null need to populate

    Robert Winkel

      I am combining the two tables below, and linking it to a third table.

      The two tables has a field I created in the load call Measure.

      1. 'ProfileOnly' as Measure,

      2. 'NewRx' as Measure,

      The third table does not have this field.

       

      How can I populate the null cell below with the word Delete?

       

       

      In my pivot table see the blank cell above NewRX.

      DATA LOAD

       

         

      LIB CONNECT TO 'pharmoresql
      LOAD FacID,
      '0' as TransType,
      ProfileOnly as Type,
      'ProfileOnly' as Measure,
      eRxMsgID;
      SQL SELECT FacID,
      ProfileOnly,
      eRxMsgID
      FROM Pat.dbo.Reorders
      Where ProfileOnly <> '0';
      LOAD
      FacID,
      TransType,
      NewRx as Type,
      'NewRx' as Measure,
      eRxMsgID;
      SQL SELECT NewRx,
      TransType,
      FacID,
      eRxMsgID
      FROM Rx.dbo.HRxs
      Where NewRx <> '0'
      and TransType <> 'Q'
      and TransType <> 'R';