4 Replies Latest reply: Oct 31, 2017 11:37 AM by Martin Hamilton RSS

    Calculate a status by evaluating 2 fields in load script

    Martin Hamilton

      Hi - I have a formula in my load script which allows me to create a new field based on the contents of other fields:

       

      IF(0 <= (SUBS_DISCONNECTED_DATE) , 'Disconnected', 'Connected') as SUBSCRIPTION_STATUS

       

      so in the below example it generates the following:

       

      SUBS_CONNECTED_DATESUBS_DISCONNECTED_DATESUBSCRIPTION_STATUS
      2017-01-01Connected
      2017-01-012017-10-10Disconnected
      Not Connected

       

      But when the SUBS_DISCONNECTION_DATE is blank AND the SUBS_CONNECTION is blank I want it to state that the SUBSCRIPTION_STATUS is Not Connected.

       

      Any guidance appreciated.

       

      thanks

       

      martin