You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Report Conversion - Replacement for If(Like...)

edited Dec 14, 2022 6:43AM in Taleo Business Edition (TBE)

Content

We currently use the Insight expression If(Like.  It was flagged as an error during the migration.  BI has If and Like functions but there isn't an example using both together.  Also, I do not see the Upper function.  Below is the original Insight expression.

IF(((LIKE(UPPER([REQU|CUSTOM_1065]),"%ASSISTANT%")= TRUE) or (LIKE(UPPER([REQU|CUSTOM_1065]),"%SECRETARY%")= TRUE)),"Y" ,"N")

This expression scanned job titles looking for the text ASSISTANT or SECRETARY.  If either was found in the title the result was sent to "Y" else "N".  In addition, our titles can be mixedcase or uppercase which is why UPPER was used in the expression.  How can I achieve the same result in BI?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!