Home
CloverETL Designer
CloverETL 4.7.0
List of Examples
14.1.
Adding an External Library to Classpath
30.1.
Finding a sort component
30.2.
Time Interval Specification
30.3.
Sorting
31.1.
Debug filter expression
32.1.
String Format
32.2.
Examples of Locale
32.3.
32.4.
Example situations when you could take advantage of multivalue fields
32.5.
Integer lists which are (not) equal - symbolic notation
36.1.
Parameter Name
36.2.
Dynamic graph parameters - usage of CTL2 as a graph parameter value
36.3.
Canonicalizing File Paths
40.1.
Example of the Error Actions Attribute
44.1.
Using public parameter
46.1.
Example jobflow log - token starting a graph
53.1.
Example State Function
53.2.
53.3.
Generating Variable Number of Records in CTL
53.4.
Example Mapping in JavaBeanReader
53.5.
Reading lists with JavaBeanReader
53.6.
Mapping in XMLExtract
53.7.
From XML Structure to Mapping Structure
53.8.
Mapping in XMLReader
53.9.
Reading lists with XMLReader
53.10.
Mapping in XMLXPathReader
54.1.
Examples of Queries
54.2.
Creating Binding
54.3.
Creating Binding
54.4.
Writing arrays
54.5.
Creating Binding
54.6.
Writing arrays
54.7.
Example of a Control script
54.8.
Writing Excel format
54.9.
Writing hyperlinks
54.10.
Using Expressions in Ports and Fields
54.11.
Include and Exclude property examples
54.12.
Attribute value examples
54.13.
Writing null attribute
54.14.
Omitting Null Attribute
54.15.
Hide Element
54.16.
Partitioning According to Any Element
54.17.
Writing and omitting blank elements
54.18.
Binding that serves as JOIN
54.19.
Insert Wildcard attributes in Source tab
55.1.
Join Key for DataIntersection
55.2.
Key for Denormalizer
56.1.
Join Key for DBJoin
56.2.
Slave Part of Join Key for ExtHashJoin
56.3.
Join Key for ExtHashJoin
56.4.
Join Key for ExtMergeJoin
56.5.
Join Key for LookupJoin
56.6.
Join Key for RelationalJoin
61.1.
CTL Mapping and multipart entities
61.2.
Working with Quoted Command Line Arguments
61.3.
Use nested nodes example
62.1.
Join Key for ApproximativeJoin
62.2.
Matching Key
63.1.
Example of CTL2 code
64.1.
Example of CTL2 syntax (Rollup)
64.2.
Example of an import of a CTL file
64.3.
Example of an import of a CTL file with a graph parameter
64.4.
Declaration of boolean variable
64.5.
Declaration of byte variable
64.6.
Declaration of cbyte variable
64.7.
Declaration of date variable
64.8.
Usage of decimal data type in CTL2
64.9.
Declaration of decimal variable
64.10.
Declaration of integer variable
64.11.
Declaration of long variable
64.12.
Declaration of number (double) variable
64.13.
Declaration of string variable
64.14.
List
64.15.
Map
64.16.
Variables
64.17.
Compound assignment operators
64.18.
Modification of a copied list, map and record
64.19.
If statement
64.20.
Switch statement
64.21.
For loop
64.22.
Mapping of Metadata by Name (using the copyByName() function)
64.23.
Mapping of Metadata by Position
64.24.
Example of Mapping with Individual Fields
64.25.
Example of Mapping with Wild Cards
64.26.
Example of Mapping with Wild Cards in Separate User-Defined Functions
64.27.
Regular Expressions Examples
66.1.
Usage of base64byte
66.2.
Usage of bits2str
66.3.
Usage of bool2num
66.4.
Usage of byte2base64
66.5.
Usage of byte2hex
66.6.
Usage of byte2str
66.7.
Usage of date2long
66.8.
Usage of date2num
66.9.
Usage of date2str
66.10.
Usage of decimal2double
66.11.
Usage of decimal2integer
66.12.
Usage of decimal2long
66.13.
Usage of double2integer
66.14.
Usage of double2long
66.15.
Usage of hex2byte
66.16.
Usage of json2xml
66.17.
Usage of long2date
66.18.
Usage of long2integer
66.19.
Usage of long2packDecimal
66.20.
Usage of md5
66.21.
Usage of num2bool
66.22.
Usage of num2str
66.23.
Usage of packDecimal2long
66.24.
Usage of sha
66.25.
Usage of sha256
66.26.
Usage of str2bits
66.27.
Usage of str2bool
66.28.
Usage of str2byte
66.29.
Usage of str2date
66.30.
Usage of str2decimal
66.31.
Usage of str2double
66.32.
Usage of str2integer
66.33.
Usage of str2long
66.34.
Usage of toString
66.35.
Usage of xml2json
66.36.
Usage of createDate
66.37.
Usage of dateAdd
66.38.
Usage of dateDiff
66.39.
Usage of extractDate
66.40.
Usage of extractTime
66.41.
Usage of getYear
66.42.
Usage of getMonth
66.43.
Usage of getDay
66.44.
Usage of getHour
66.45.
Usage of getMinute
66.46.
Usage of getSecond
66.47.
Usage of getMillisecond
66.48.
Usage of randomDate
66.49.
Usage of today
66.50.
Usage of abs
66.51.
Usage of acos
66.52.
Usage of asin
66.53.
Usage of atan
66.54.
Usage of bitAnd
66.55.
Usage of bitIsSet
66.56.
Usage of bitLShift
66.57.
Usage of bitNegate
66.58.
Usage of bitOr
66.59.
Usage of bitRShift
66.60.
Usage of bitSet
66.61.
Usage of bitXor
66.62.
Usage of ceil
66.63.
Usage of cos
66.64.
Usage of e
66.65.
Usage of exp
66.66.
Usage of floor
66.67.
Usage of log
66.68.
Usage of log10
66.69.
Usage of max
66.70.
Usage of min
66.71.
Usage of pi
66.72.
Usage of pow
66.73.
Usage of random
66.74.
Usage of randomBoolean
66.75.
Usage of randomGaussian
66.76.
Usage of randomInteger
66.77.
Usage of randomLong
66.78.
Usage of round
66.79.
Usage of roundHalfToEven
66.80.
Usage of setRandomSeed
66.81.
Usage of signum
66.82.
Usage of sin
66.83.
Usage of sqrt
66.84.
Usage of tan
66.85.
Usage of toDegrees
66.86.
Usage of toRadians
66.87.
Usage of byteAt
66.88.
Usage of charAt
66.89.
Usage of chop
66.90.
Usage of codePointAt
66.91.
Usage of codePointLength
66.92.
Usage of codePointToChar
66.93.
Usage of concat
66.94.
Usage of concatWithSeparator
66.95.
Usage of contains
66.96.
Usage of countChar
66.97.
Usage of cut
66.98.
Usage of editDistance 1
66.99.
Usage of editDistance 2
66.100.
Usage of editDistance 3
66.101.
Usage of editDistance 4
66.102.
Usage of editDistance 5
66.103.
Usage of editDistance 6
66.104.
Usage of editDistance 7
66.105.
Usage of endsWith
66.106.
Usage of escapeUrl
66.107.
Usage of escapeUrlFragment
66.108.
Usage of find
66.109.
Usage of getAlphanumericChars
66.110.
Usage of getComponentProperty
66.111.
Usage of getFileExtension
66.112.
Usage of getFileName
66.113.
Usage of getFileNameWithoutExtension
66.114.
Usage of getFilePath
66.115.
Usage of getUrlHost
66.116.
Usage of getUrlPath
66.117.
Usage of getUrlPort
66.118.
Usage of getUrlProtocol
66.119.
Usage of getUrlQuery
66.120.
Usage of getUrlRef
66.121.
Usage of getUrlUserInfo
66.122.
Usage of indexOf
66.123.
Usage of isAscii
66.124.
Usage of isBlank
66.125.
Usage of isDate
66.126.
Usage of isDecimal
66.127.
Usage of isEmpty
66.128.
Usage of isInteger
66.129.
Usage of isLong
66.130.
Usage of isNumber
66.131.
Usage of isUnicodeNormalized
66.132.
Usage of isUrl
66.133.
Usage of isValidCodePoint
66.134.
Usage of join
66.135.
Usage of lastIndexOf
66.136.
Usage of left
66.137.
Usage of length
66.138.
Usage of lowerCase
66.139.
Usage of lpad
66.140.
Usage of matches
66.141.
Usage of matchGroups
66.142.
Usage of metaphone
66.143.
Usage of normalizePath
66.144.
Usage of NYSIIS
66.145.
Usage of randomString
66.146.
Usage of randomUUID
66.147.
Usage of removeBlankSpace
66.148.
Usage of removeDiacritic
66.149.
Usage of removeNonAscii
66.150.
Usage of removeNonPrintable
66.151.
Usage of replace
66.152.
Usage of reverse
66.153.
Usage of right
66.154.
Usage of rpad
66.155.
Usage of soundex
66.156.
Usage of split
66.157.
Usage of startsWith
66.158.
Usage of substring
66.159.
Usage of toProjectURL
66.160.
Usage of translate
66.161.
Usage of trim
66.162.
Usage of unescapeUrl
66.163.
Usage of unescapeUrlFragment
66.164.
Usage of unicodeNormalize
66.165.
Usage of upperCase
66.166.
Usage of getMappedSourceFields()
66.167.
Usage of getMappedTargetFields()
66.168.
Usage of isSourceFieldMapped()
66.169.
Usage of isTargetFieldMapped()
66.170.
Usage of append
66.171.
Usage of binarySearch
66.172.
Usage of clear
66.173.
Usage of clear
66.174.
Usage of containsAll
66.175.
Usage of containsKey
66.176.
Usage of containsValue
66.177.
Usage of copy
66.178.
Usage of copy
66.179.
Usage of getKeys
66.180.
Usage of getValues
66.181.
Usage of insert
66.182.
Usage of isEmpty
66.183.
Usage of isEmpty
66.184.
Usage of length:
66.185.
Usage of poll
66.186.
Usage of pop
66.187.
Usage of push
66.188.
Usage of remove
66.189.
Usage of reverse
66.190.
Usage of sort
66.191.
Usage of toMap
66.192.
Usage of compare
66.193.
Usage of copyByName
66.194.
Usage of copyByPosition
66.195.
Usage of getBoolValue
66.196.
Usage of getByteValue
66.197.
Usage of getDateValue
66.198.
Usage of DecimalValue
66.199.
Usage of getFieldIndex
66.200.
Usage of getFieldLabel
66.201.
Usage of getFieldName
66.202.
Usage of getFieldProperties
66.203.
Usage of getFieldType
66.204.
Usage of getIntValue
66.205.
Usage of getLongValue
66.206.
Usage of getNumValue
66.207.
Usage of getRecordProperties
66.208.
Usage of getStringValue
66.209.
Usage of getValueAsString
66.210.
Usage of isNull
66.211.
Usage of length
66.212.
Usage of resetRecord
66.213.
Usage of setBoolValue
66.214.
Usage of setByteValue
66.215.
Usage of setDateValue
66.216.
Usage of seDecimalValue
66.217.
Usage of setIntValue
66.218.
Usage of setLongValue
66.219.
Usage of setNumValue
66.220.
Usage of setStringValue
66.221.
Usage of getEnvironmentVariables()
66.222.
Usage of getJavaProperties()
66.223.
Usage of getParamValue
66.224.
Usage of getParamValues
66.225.
Usage of getRawParamValue
66.226.
Usage of getRawParamValues
66.227.
Usage of hashCode
66.228.
Usage of iif
66.229.
Usage of isnull
66.230.
Usage of nvl
66.231.
Usage of nvl2
66.232.
Sample property file
66.233.
Usage of parseProperties
66.234.
Usage of printErr
66.235.
Usage of printErr 2
66.236.
Usage of printLog
66.237.
Usage of raiseError
66.238.
Usage of resolveParams
66.239.
Usage of sleep
66.240.
Usage of toAbsolutePath
66.241.
Usage of count
66.242.
Usage of get
66.243.
Usage of next
66.244.
Usage of put
66.245.
Usage of Lookup Table Functions
66.246.
Usage of getSubgraphInputPortsCount
66.247.
Usage of getSubgraphOutputPortsCount
66.248.
Usage of isSubgraphInputPortConnected
66.249.
Usage of isSubgraphOutputPortConnected
66.250.
Usage of addResponseHeader
66.251.
Usage of containsResponseHeader
66.252.
Usage of getRequestBody
66.253.
Usage of getRequestClientIPAddress
66.254.
Usage of getRequestContentType
66.255.
Usage of getRequestEncoding
66.256.
Usage of getRequestHeader
66.257.
Usage of getRequestHeaderNames
66.258.
Usage of getRequestHeaders
66.259.
Usage of getRequestMethod
66.260.
Usage of getRequestParameter
66.261.
Usage of getRequestParameterNames
66.262.
Usage of getRequestParameters
66.263.
Usage of getRequestPartFilename
66.264.
Usage of getResponseContentType
66.265.
Usage of getResponseEncoding
66.266.
Usage of setRequestEncoding
66.267.
Usage of getResponseBody
66.268.
Usage of setResponseContentType
66.269.
Usage of setResponseEcncoding
66.270.
Usage of setResponseHeader
66.271.
Usage of setResponseStatus