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...
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>)
Tagged:
0