Transformation

2023

If Null
If Null Or Empty String
Transformation Action
XML Transformation Action
Is Australian Phone Number
Working with Transformer
Working with Validator
IP Location
URL Location
Subtract
How to split a file with Advanced ETL Processor
Making ETL Objects Read Only
Processing files based on modification date
Things to avoid while designing data transformations
Understanding Transformation Metadata
Update is slow
Get Excel Cell Value
Get Excel Cell Value Dynamic
Replace Characters
Contains
Decode JSON Array
Decode JSON Object
Decode JSON Pair
Decode JSON String
Encode JSON Array
Encode JSON Object
Encode JSON Pair
Encode JSON String
If Algerian Post Code
If Andorran IBAN
If Andorran Post Code
If Argentinian Post Code
If Australian Mobile Number
If Australian Phone Number
If Australian Post Code
If Austrian Mobile Phone Number
If Azerbaijani Post Code
If Bahraini Post Code
If Bangladeshi Post Code
If Belarusian Post Code
If Belgian Post Code
If Belgian VAT Number
If Brunei Post Code
If Canadian Branch-Transit/ Bank code
If Canadian Provincial Code
If Canadian Social Insurance Number
If Canadian Zip Code
If Chilean Post Code
If Credit Card
If Croatian Post Code
If Cyprus Post Code
If Cyprus VAT Number
If Czech Republic IBAN
If Czech Republic VAT Number
If Danish Civil Registration Number
If Danish Phone Number
If Danish Post Code
If Danish VAT Number
If Dutch Car Number Plate
If Dutch Phone Number
If Dutch Post Code
If Egyptian Post Code
If Email
If Estonian Post Code
If Estonian VAT Number
If Ethiopian Post Code
If Faroe Islands Post Code
If File Name
If Finnish VAT Number
If French Phone Number
If French Polynesia Post Code
If French Post Code
If French VAT Number
If German Car License Plate
If German IBAN
If German Post Code
If German VAT Number
If Greek VAT Number
If Guadeloupe Post Code
If Guinea-Bissau Post Code
If Guinean Post Code
If Hungarian VAT Number
If Indian Mobile Number
If Indian Phone Number
If Indian Post Code
If Indian Vehicle Registration Number
If IP Address V4
If IP Address V6
If Irish VAT Number
If ISBN 10
If ISBN 13
If Israeli Mobile Phone Number
If Israeli Phone Number
If Italian IBAN
If Italian Mobile Number
If Italian Phone Number
If Italian Post Code
If Italian VAT Number
If Latvian VAT Number
If Lithuanian VAT Number
If Luxembourg VAT Number
If Maltese VAT Number
If Matches Regular Expression
If Netherlands VAT Number
If Peru Cellular Number
If Peru Phone Number
If Polish IBAN
If Polish VAT Number
If Portuguese VAT Number
If Russian Phone Number
If Russian Post Code
If Slovakian IBAN
If Slovakian VAT Number
If Slovenian VAT Number
If South African Company Number
If South African Mobile Number
If South African Phone Number
If South African VAT Number
If Spanish IBAN
If Spanish Phone Number
If Spanish Post Code
If Spanish VAT Number
If Swedish IBAN
If Swedish Person Number
If Swedish Phone Number
If Swedish Post Code
If Swedish VAT Number
If Swiss Mobile Number
If Swiss Phone Number
If Swiss Post code
If UK Bank Sort Code
If UK Driver License
If UK Mobile Number
If UK National Insurance Number
If UK Phone Number
If UK Post Code
If UK Vat Number
If UK Vehicle Registration Number
If UNC
If URL
If US or CA Zip code
If US Phone Number
If US Social Security Number
If US State
If US Zip Code
In List
Is 1st Quarter
Is Algerian Post Code
Is Alpha
Is Alpha Numeric
Is AM
Is Andorran IBAN
Is Andorran Post Code
Is Argentinian Post Code
Is Australian Mobile Number
Is Australian Post Code
Is Austrian Mobile Phone Number
Is Azerbaijani Post Code
Is Bahraini Post Code
Is Bangladeshi Post Code
Is Belarusian Post Code
Is Belgian Post Code
Is Belgian VAT Number
Is Brunei Post Code
Is Canadian Branch-Transit/Bank code
Is Canadian Provincial Code
Is Canadian Social Insurance Number
Is Canadian Zip Code
Is Chilean Post Code
Is Credit Card
Is Croatian Post Code
Is Current Week
Is Cyprus Post Code
Is Cyprus VAT Number
Is Czech Republic IBAN
Is Czech Republic VAT Number
Is Danish Civil Registration Number
Is Danish Phone Number
Is Danish Post Code
Is Danish VAT Number
Is Date
Is Date Between
Is Date Less Than
Is Date More Than
Is Dutch Car Number Plate
Is Dutch Phone Number
Is Dutch Post Code
Is Egyptian Post Code
Is Email
Is Empty String
Is Ends With
Is Equal To
Is Estonian Post Code
Is Estonian VAT Number
Is Ethiopian Post Code
Is Faroe Islands Post Code
Is File Name
Is Finnish VAT Number
Is French Phone Number
Is French Polynesia Post Code
Is French Post Code
Is French VAT Number
Is German Car License Plate
Is German IBAN
Is German Post Code
Is German VAT Number
Is Greek VAT Number
Is Guadeloupe Post Code
Is Guinea-Bissau Post Code
Is Guinean Post Code
Is Hex
Is Hour 12
Is Hour 24
Is Hungarian VAT Number
Is Indian Mobile Number
Is Indian Phone Number
Is Indian Post Code
Is Indian Vehicle Registration Number
Is Integer
Is IP Address V4
Is IP Address V6
Is Irish VAT Number
Is ISBN 10
Is ISBN 13
Is Israeli Mobile Phone Number
Is Israeli Phone Number
Is Italian IBAN
Is Italian Mobile Number
Is Italian Phone Number
Is Italian Post Code
Is Italian VAT Number
Is January
Is Latvian VAT Number
Is Leap Year
Is Lithuanian VAT Number
Is Luxembourg VAT Number
Is Maltese VAT Number
Is Minute
Is Monday
Is Negative
Is Netherlands VAT Number
Is Null
Is Null or Empty String
Is Number
Is Number Between
Is Number Less Than
Is Number More Than
Is Peru Cellular Number
Is Peru Phone Number
Is PM
Is Polish IBAN
Is Polish VAT Number
Is Portuguese VAT Number
Is Positive
Is Russian Phone Number
Is Russian Post Code
Is Second
Is Slovakian IBAN
Is Slovakian VAT Number
Is Slovenian VAT Number
Is South African Company Number
Is South African Mobile Number
Is South African Phone Number
Is South African VAT Number
Is Spanish IBAN
Is Spanish Phone Number
Is Spanish Post Code
Is Spanish VAT Number
Is Starts With
Is Swedish IBAN
Is Swedish Person Number
Is Swedish Phone Number
Is Swedish Post Code
Is Swedish VAT Number
Is Swiss Mobile Number
Is Swiss Phone Number
Is Swiss Post code
Is Time
Is Time Between
Is Time Less Than
Is Time More Than
Is UK Bank Sort Code
Is UK Driver License
Is UK Mobile Number
Is UK National Insurance Number
Is UK Phone Number
Is UK Post Code
Is UK VAT Number
Is UK Vehicle Registration Number
Is UNC
Is URL
Is US or CA Zip code
Is US Phone Number
Is US Social Security Number
Is US State
Is US Zip Code
Is Valid XML
Is Value in the database
Is Within Past Minutes
Regular Expression
Replace RegX
Split RegX Dynamic
Split RegX Static

2022

Getting Started
Working with Writer
Abs
Accumulate Strings
Add
After
Before
Calculation
Case Transformation
Checksum
Command Line Parameter
Compare Values
Concatenate
Current Date
Decode Base 64
Decode HTML
Decode HTTP
Decode XML Attribute
Decode XML Element
Decode XML String
Delete
Delete Characters
Delete Leading Characters
Delete Spaces
Delete Trailing Characters
Directory Name
Divide
Encode Base 64
Encode HTML
Encode HTTP
Encode XML Element
Encode XML String
Ensure No Prefix
Ensure No Suffix
Ensure Prefix
Ensure Suffix
Epoch to Date
Escape String
Field Value
File Name
First Up
Get File Content
Get File Content Dinamic
Get Line
Get Package Variable
Get Variable
GUID
HTTP Get
HTTP Post
If 1st Quarter, If 2nd Quarter, Is 3rd Quarter, Is 4th Quarter, Is Current Quarter, Is Last Quarter, Is Next Quarter
If Alpha
If Alpha Numeric
If AM
If Contains
If Current Week, If Last Week, If Next Week
If Date
If Date Between
If Date Less Than
If Date More Than
If Empty String
If Ends With
If Equal To
If Hex
If Hour 12
If Hour 24
If Integer
If January, If February, If March, If April, If May, If June, If July, If August, Is September, If October, If November, If December, If Current Month, If Last Month, If Next Month
If Leap Year, If Current Year, If Last Year, If Next Year
If Minute
If Monday, If Tuesday, If Wednesday, If Thursday, If Friday, If Saturday, If Sunday, If Today, If Yesterday, If Tomorrow, If Weekend, If Weekday
If Negative
If Number
If Number Between
If Number Less
If Number More Than
If PM
If Positive
If Second
If Starts With
If Time
If Time Between
If Time Less Than
If Time More Than
If Valid XML
If Value in the database
If Within Past Minutes, If Within Past Hours, If Within Past Days, If Within Past Weeks, If Within Past Months
In Place Replace
Keep Characters
Keep Value
Left
Left Delete
Left Pad
Left Trim
Length
Literal
Lower Case
Metadata
Multiply
Previous Value
Proper Case
Random Number
Replace
Right
Right Delete
Right Pad
Right Trim
Round
Running Total
Set Package Variable
Set Variable
Sign
Split
Sub String
Sub Transformation
Trim
UnEscape String
Upper Case
User
Working with Clone Rows Object
Working with Data Buffer Object
Working with Deduplicator
Working with Fields Selector Object
Working with Fields Values Object
Working with Grouper
Working with Joiner Object
Working with Log Object
Working with Pivot
Working with Reader
Working with Sorter
Working with Union All Object
XML XSLT Transformation
Lookup
Lookup Replace
Mapping Screen Overview
Range Lookup
SQL Lookup
Working with UnPivot
Change Date
Change Date Dynamic
Date Diff
Date Format
Date part
Date to Epoch
Local Date to UTC
Reformat Date
UTC to Local Date
Back to Main Site About Support Pricing Cookies Policy Term Of Use Privacy Policy License