11 Replies Latest reply: Jun 21, 2018 10:27 AM by Elizabeth Viso RSS

    Separating Data

    Elizabeth Viso

      Hello everyone,

       

      I have data that I am separating into two other columns which I got working:

       

      Capture.PNG

      So I take Failure Mode and break it down into WorkOrder and Reason by adding this to the script:

       

      [Failure Mode] AS [Failure Mode],

          subfield([Failure Mode],':',1) AS WorkOrder,

          subfield([Failure Mode],':',-1) AS Reason,

       

      But for WorkOrder I only want it to show the WorkOrder number if the failure mode has one. How can I do that?

       

      Thank you!