Dear All,
I recently asked a question how to fill missing values in a column and got/implemented the solution. But I am stuck again. This problem is the continuation of the same (2nd stage issue.)
Reference of previous problem -
https://community.jmp.com/t5/Discussions/How-to-fill-replace-text-between-two-cells-based-on-specifi...
I want to generate a column "Device_State_Final_Corrected" in the attached data, based on "Device_ID", "Device_State_Final" and following rules -
---------------------------------------------------------------------------------------
For Each device, well define Order is -
"Initialization - Ramp - Heat - Ramp_2 - Ramp_Down -Final"
Two rules to follow -
Rule 1. If a higher state is appeared once (say, "Ramp_2"), lower state (say, "Initillization") can not appear. If it is appearing, it would be replace with the previously occurrent higher state (by "Ramp_2") - see row number - 12. Exception occurs for device state "Heat"
Rule 2. Now if somewhere if device is heating up, it should repeat the sequence after "Heat" and following rule 1.
"Initialization - Ramp - Heat - Ramp_2 - Ramp_Down -Heat - Ramp_2 - Ramp_Down - Final" -- See the row number 24, 25, 26.
---------------------------------------------------------------------------------------
Any help,
Thanks - HSS