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:



      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!