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

Question
4
Views
0
Comments

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...


ABS(<Value>)

EDATE(<Date>, <Months>)

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

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

DAY(<Date>)

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

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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