I have create a Transform that is throwing an error:
There was an exception while calculating the value for this attribute. Error during transformation for attribute: cfsalesforcealias (Transform ID: Calculate cfsalesforcealias) Cause: An empty regex expression may not be used for target value:
The issue wasn’t with the transform structure, but with how replaceAll was being used.
the transform was using a hardcoded two-space pattern instead of a regex pattern for whitespace matching. “\\s+" matches one or more consecutive whitespace characters.
replaceAll with “\\s+” works in this case. However, as clean solution I’d use replace because it have only one pattern to remove. if there are multiple replace operations patterns replaceAll with table of key-value pairs would better. Thanks