Elixir Transform

Release 3.5.0

Elixir Technology Pte Ltd

All rights reserved.

Java is a trademark or registered trademark of Oracle Corporation in the United States and other countries. Microsoft and Windows are trademarks of Microsoft Corporation.

2014


Table of Contents

1. Transform
Overview
Launching the Transforms Editor
Static and Dynamic Transforms
Merge and Retain Operations
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
Date difference (in days)
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
Time difference (in ms)
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
Timestamp difference (in days)
Timestamp difference (in ms)
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. Constant, Discard, Discard Duplicates, Reduce, Retain and Security Transforms
Constant Transform
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
Retain Transform
Security Transform
Column
Row
Row Credentials
Table

List of Figures

1.1. Add Datasource Option
1.2. Composite Datasource
1.3. Naming the Datasource
1.4. Securing the Datasource
1.5. Transforms Editor
1.6. Trim Option

List of Tables

6.1. Shared input of Reduce Transform
6.2. Shared input of Security Transform