Copyright © 2015 Elixir Technology Pte Ltd

2015

**Table of Contents**

- 1. Transform
- 2. Boolean and String Transforms
- Boolean Transform
- String Transform
- Add prefix
- Add suffix
- Ascii to zenkaku alphanumeric
- Capitalize
- Contains
- 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
- ReplaceRegExp
- 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

- 4. Date, Time and Timestamp Transforms
- Date Transform
- Time Transform
- 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. Projection Transform
- 6. Compare, Sequence and Sort Transforms
- 7. Constant, Discard, Discard Duplicates, Reduce, Retain and Security Transforms
- 8. Clustering Transform

**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
- 5.1. Projection Transform
- 5.2. Projection Transform Results
- 8.1. Clustering Transform
- 8.2. Clustering Transform Configuration
- 8.3. Clustering Transform Results as a Table
- 8.4. Clustering Transform Results as a Bubble Chart

**List of Tables**