Elixir Transform
		Next

Elixir Transform

Release 8.5

Elixir Technology Pte Ltd

Solaris, Java and all Java-based trademarks and logos are trademarks or registered trademarks of Sun Microsystems, Inc. Microsoft and Windows are trademarks of Microsoft Corporation.

2012

Table of Contents

1. Transform

Overview

Dynamic Transform
Merge and Retain
Example
Summary

2. Boolean and String Transforms

Boolean Transform

And
Discard
Not
Or
Retain
To either

String Transform

Add prefix
Add suffix
Ascii to zenkaku alphanumeric
Capitalize
Count
Ends with
Enumeration to boolean
Enumeration to integer
Extract
First
Hankaku katakana to zenkaku katakana
Hiragana to katakana
Index of
Katakana to hiragana
Last
Last index of
Left pad
Left trim
Lower
Matches
Merge
Null to string
Replace
Right pad
Right trim
Slice
Split
Starts with
Trim
Upper
Zenkaku alphanumeric to ascii
Zenkaku katakana to hankaku katakana

3. Decimal, Float and Integer Transforms

Decimal Transform

Add
Average merge
Average retain
Divide
Max
Max merge
Max retain
Median merge
Median retain
Min
Min merge
Min retain
Multiply
Percent
Product merge
Product retain
Remainder
Round down
Round half down
Round half even
Round half up
Round up
Standard deviation merge
Standard deviation retain
Subtract
Sum merge
Sum retain
To ceiling
To floor
Variance merge
Variance retain

Float Transform

Add
Average merge
Average retain
Divide
Max
Max merge
Max retain
Median merge
Median retain
Min
Min merge
Min retain
Multiply
Percent
Product merge
Product retain
Remainder
Round down
Round half down
Round half even
Round half up
Round up
Standard deviation merge
Standard deviation retain
Subtract
Sum merge
Sum retain
To ceiling
To floor
Variance merge
Variance retain

Integer Transform

Add
Average merge
Average retain
Divide
Max
Max merge
Max retain
Median merge
Median retain
Min
Min merge
Min retain
Multiply
Percent
Product merge
Product retain
Remainder
Standard deviation merge
Standard deviation retain
Subtract
Sum merge
Sum retain
Variance merge
Variance retain

4. Date, Time and Timestamp Transforms

Date Transform

Add days
Add months
Add years
Day
First of month
Last of month
Max
Min
Month
Month name (long)
Month name (short)
Null to date
Quarter
Quarter name (short)
Set day
Set month
Set year
Subtract days
Subtract months
Subtract years
To string format
Truncate
Year

Time Transform

Add hours
Add milliseconds
Add minutes
Add seconds
Am
Hours
Max
Milliseconds
Min
Minutes
Null to time
Pm
Seconds
Set hour
Set millisecond
Set minute
Set second
Subtract hours
Subtract milliseconds
Subtract minutes
Subtract seconds
To milliseconds
To seconds
To string format

Timestamp Transform

Add days
Add hours
Add milliseconds
Add minutes
Add months
Add seconds
Add years
Am
Day
First of month
Hours
Last of month
Max
Milliseconds
Min
Minutes
Month
Month name (long)
Month name (short)
Null to timestamp
Pm
Quarter
Quarter name (short)
Seconds
Set day
Set hour
Set millisecond
Set minute
Set month
Set second
Set year
Subtract days
Subtract hours
Subtract milliseconds
Subtract minutes
Subtract months
Subtract seconds
Subtract years
To milliseconds
To seconds
Truncate
Year

5. Compare, Sequence and Sort Transforms

Compare Transform

Equal
Less than
Less than or equal
More than
More than or equal
Next equal
Next less than
Next less than or equal
Next more than
Next more than or equal
Next not equal
Not equal
Previous equal
Previous less than
Previous less than or equal
Previous more than
Previous more than or equal
Previous not equal

Sequence Transform

Per group
Per record
Record per group
Round robin
Top

Sort Transform

6. Discard, Discard Duplicates, Reduce and Security Transforms

Discard Transform

Discard Duplicates Transform

Reduce Transform

Average
Comma Separated List
Comma Separated Set
Count
First
Last
Max
Median
Min
Product
Standard Deviation
Sum
Variance

Security Transform

List of Tables

6.1. Shared input