"Case when" type syntax in Formulas

[Kboisvert]

I have a series of lots imported as conditions from a csv file.
I am calculating a transition analysis, which requires the manual input of the packed bed height. 
I want to write some kind of formula that says "when lot number = 12345, then bed height=22. When lot number =45678 then bed height=25, etc". Any suggestions?

[Joe Reckamp]

Hello,

You can use the replace function in formula to do this.

Alternately, a lot of customers use the manual signal option: https://support.seeq.com/kb/latest/cloud/manual-signal to just input bed height at various timestamps.

[Thorsten Vogt]

Hi, 

you can do this by using splice(). The following example takes 10 as the default value and changes the part of the signal to 15 or 22 based on the value of the batch id.
 

If the lot number you mentioned is a property of the capsule you imported you might need to convert it to a signal using toSignal() and the property name that is used to store the lot number:

Or filter for capsules that contain the lot number using keep() on the condition:

You can check your capsules for existing properties by having a look at the Capsules Pane. When clicking the "Add Column" icon you are able to choose the properties from the dropdownlist of available properties. The name of the property can be used in the functions mentioned above.

Regards,

Thorsten