This content has been marked as final. Show 11 replies
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?