Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Transaction Matching - Calculated Attribute Available Functions — Cloud Customer Connect
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

Transaction Matching - Calculated Attribute Available Functions


Hi All,

I need to review the reference document for the allowed script functions in TM data source setup screen; and how often new functions will be introduced.

So far below functions are available in the system; however I need LPAD, REPLACE, RPAD kind of frequently used string functions too, not sure if anyone needed it before.

Alternate ways are possible, like using combination of multiple functions below or using DM; but just asking out of curiosity...


EDATE(<Date>, <Months>)

DATE(<Year>, <Month>, <Day>)

DATE_DIFF(<Date1>, <Date2>, <Type>)


SUBSTRING(<Value>, <Location>, <Length>)

IF_THEN_ELSE(<Condition>, <Value1>, <Value2>)

Howdy, Stranger!

Log In

To view full details, sign in.


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