Data Exchange Data Mapping Target Expression SQL Case statement

Summary:

In an EPM Planning Data Exchange integration, I need to replace a parent value and member value of “T” with another value like “T_Fund”. I cannot use Replace() function as this will impact other members with “T” in their name. I have tied using the SQL(“Case $ENTITY$ WHEN ‘T’ THEN ‘T_Fund” ELSE $ENTITY$ END”) but I am receiving an error during integration execution. I think the second $ENTITY$ is not be evaluated correctly.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):