{"id":28035,"date":"2017-06-16T15:05:30","date_gmt":"2017-06-16T07:05:30","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=28035"},"modified":"2024-08-15T10:31:32","modified_gmt":"2024-08-15T02:31:32","slug":"switch","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/switch\/","title":{"rendered":"Switch()"},"content":{"rendered":"\n

Format<\/h2>\n

Switch(InputValues ,Case1Value ,Case1Result ,Case2Value ,Case2Result [,OtherCases])<\/strong><\/p>\n

Returns<\/h2>\n

Returns the replacement value for each input value based on which cases were matched for each individual input value.<\/p>\n

Inputs<\/h2>\n

InputValues: <\/b>The input values that the function will compare to available cases and replace.
\nBehaviour: Required
\nDimensions: Collection, SingleValue, MultiCollection
\nValid data types: Null, Boolean, DateTime, Decimal, Integer, String, Duration<\/p>\n

Case1Value: <\/b>The value of the first case.
\nBehaviour: Required
\nDimensions: SingleValue
\nValid data types: Null, Boolean, DateTime, Decimal, Integer, String, Duration<\/p>\n

Case1Result: <\/b>The expression which will be (lazily) evaluated and used to replace the input value if it matched the value of this case.
\nBehaviour: Required
\nDimensions: SingleValue
\nValid data types: String<\/p>\n

Case2Value: <\/b>The value of the second case.
\nBehaviour: Required
\nDimensions: SingleValue
\nValid data types: Null, Boolean, DateTime, Decimal, Integer, String, Duration<\/p>\n

Case2Result: <\/b>The expression which will be (lazily) evaluated and used to replace the input value if it matched the value of this case.
\nBehaviour: Required
\nDimensions: SingleValue
\nValid data types: String<\/p>\n

OtherCases: <\/b>Subsequent cases must follow the existing pattern. I.e. even numbered parameters must contain possible values, odd numbered subsequent parameters must contain the expression which will be (lazily) evaluated and used to replace the input value.
\nBehaviour: ParamsArray
\nDimensions: SingleValue
\nValid data types: Null, Boolean, DateTime, Decimal, Integer, String, Duration<\/p>\n

How to format data types<\/a><\/p>\n

Examples<\/h2>\n

Expression: Switch(1 + 1, 1, \"'case 1'\", 2, \"'case 2'\", 3, \"'case 3'\")
\nResult: Returns the string \"case 2\".<\/p>\n

Expression: Switch({Tag1}, 1, \"{Tag2}\", 2, \"{Tag3}\", 3, \"{Tag4}\")
\nResult: Returns the last known value from {Tag2}, {Tag3} and {Tag4} for every 1, 2 or 3 value found in {Tag1}.<\/p>\n

Release History<\/span><\/h2>\n