Home
CloverDX Designer
CloverDX 5.1.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
33.1.
Properties needed to connect to a Hadoop High Availability (HA) cluster in Hadoop connection
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
45.1.
Using public parameter
47.1.
Example jobflow log - token starting a graph
55.1.
Example State Function
55.2.
55.3.
Generating Variable Number of Records in CTL
55.4.
Generating Random Values with Fixed Random Seed
55.5.
Example Mapping in JavaBeanReader
55.6.
Reading lists with JavaBeanReader
55.7.
Mapping in XMLExtract
55.8.
From XML Structure to Mapping Structure
55.9.
Mapping in XMLReader
55.10.
Reading lists with XMLReader
55.11.
Mapping in XMLXPathReader
56.1.
Examples of Insert Queries
56.2.
Examples of Update and Delete Queries
56.3.
Creating Binding
56.4.
Creating Binding
56.5.
Writing arrays
56.6.
Creating Binding
56.7.
Example of a Control script
56.8.
Writing Excel format
56.9.
Writing hyperlinks
56.10.
Using Expressions in Ports and Fields
56.11.
Include and Exclude property examples
56.12.
Attribute value examples
56.13.
Writing null attribute
56.14.
Omitting Null Attribute
56.15.
Hide Element
56.16.
Partitioning According to Any Element
56.17.
Writing and omitting blank elements
56.18.
Binding that serves as JOIN
56.19.
Insert Wildcard attributes in Source tab
57.1.
Join Key for DataIntersection
57.2.
Key for Denormalizer
58.1.
Join Key for DBJoin
58.2.
Slave Part of Join Key for ExtHashJoin
58.3.
Join Key for ExtHashJoin
58.4.
Join Key for ExtMergeJoin
58.5.
Join Key for LookupJoin
58.6.
Join Key for RelationalJoin
63.1.
CTL Mapping and multipart entities
63.2.
Working with Quoted Command Line Arguments
63.3.
Use nested nodes example
64.1.
Join Key for ApproximativeJoin
64.2.
Matching Key
65.1.
Example of CTL2 code
66.1.
Example of CTL2 syntax (Rollup)
66.2.
Example of an import of a CTL file
66.3.
Example of an import of a CTL file with a graph parameter
66.4.
Declaration of boolean variable
66.5.
Declaration of byte variable
66.6.
Declaration of cbyte variable
66.7.
Declaration of date variable
66.8.
Usage of decimal data type in CTL2
66.9.
Declaration of decimal variable
66.10.
Declaration of integer variable
66.11.
Declaration of long variable
66.12.
Declaration of number (double) variable
66.13.
Declaration of string variable
66.14.
List
66.15.
Map
66.16.
Variables
66.17.
Compound assignment operators
66.18.
Modification of a copied list, map and record
66.19.
If statement
66.20.
Switch statement
66.21.
For loop
66.22.
Mapping of Metadata by Name (using the copyByName() function)
66.23.
Mapping of Metadata by Position
66.24.
Example of Mapping with Individual Fields
66.25.
Example of Mapping with Wild Cards
66.26.
Example of Mapping with Wild Cards in Separate User-Defined Functions
66.27.
Regular Expressions Examples
68.1.
Usage of base64byte
68.2.
Usage of bits2str
68.3.
Usage of bool2num
68.4.
Usage of byte2base64
68.5.
Usage of byte2hex
68.6.
Usage of byte2str
68.7.
Usage of date2long
68.8.
Usage of date2num
68.9.
Usage of date2str
68.10.
Usage of decimal2double
68.11.
Usage of decimal2integer
68.12.
Usage of decimal2long
68.13.
Usage of double2integer
68.14.
Usage of double2long
68.15.
Usage of hex2byte
68.16.
Usage of json2xml
68.17.
Usage of long2date
68.18.
Usage of long2integer
68.19.
Usage of long2packDecimal
68.20.
Usage of md5
68.21.
Usage of num2bool
68.22.
Usage of num2str
68.23.
Usage of packDecimal2long
68.24.
Usage of sha
68.25.
Usage of sha256
68.26.
Usage of str2bits
68.27.
Usage of str2bool
68.28.
Usage of str2byte
68.29.
Usage of str2date
68.30.
Usage of str2decimal
68.31.
Usage of str2double
68.32.
Usage of str2integer
68.33.
Usage of str2long
68.34.
Usage of toString
68.35.
Usage of xml2json
68.36.
Usage of createDate
68.37.
Usage of dateAdd
68.38.
Usage of dateDiff
68.39.
Usage of extractDate
68.40.
Usage of extractTime
68.41.
Usage of getYear
68.42.
Usage of getMonth
68.43.
Usage of getDay
68.44.
Usage of getHour
68.45.
Usage of getMinute
68.46.
Usage of getSecond
68.47.
Usage of getMillisecond
68.48.
Usage of randomDate
68.49.
Usage of today
68.50.
Usage of abs
68.51.
Usage of acos
68.52.
Usage of asin
68.53.
Usage of atan
68.54.
Usage of bitAnd
68.55.
Usage of bitIsSet
68.56.
Usage of bitLShift
68.57.
Usage of bitNegate
68.58.
Usage of bitOr
68.59.
Usage of bitRShift
68.60.
Usage of bitSet
68.61.
Usage of bitXor
68.62.
Usage of ceil
68.63.
Usage of cos
68.64.
Usage of e
68.65.
Usage of exp
68.66.
Usage of floor
68.67.
Usage of log
68.68.
Usage of log10
68.69.
Usage of max
68.70.
Usage of min
68.71.
Usage of pi
68.72.
Usage of pow
68.73.
Usage of random
68.74.
Usage of randomBoolean
68.75.
Usage of randomGaussian
68.76.
Usage of randomInteger
68.77.
Usage of randomLong
68.78.
Usage of round
68.79.
Usage of roundHalfToEven
68.80.
Usage of setRandomSeed
68.81.
Usage of signum
68.82.
Usage of sin
68.83.
Usage of sqrt
68.84.
Usage of tan
68.85.
Usage of toDegrees
68.86.
Usage of toRadians
68.87.
Usage of byteAt
68.88.
Usage of charAt
68.89.
Usage of chop
68.90.
Usage of codePointAt
68.91.
Usage of codePointLength
68.92.
Usage of codePointToChar
68.93.
Usage of concat
68.94.
Usage of concatWithSeparator
68.95.
Usage of contains
68.96.
Usage of countChar
68.97.
Usage of cut
68.98.
Usage of editDistance 1
68.99.
Usage of editDistance 2
68.100.
Usage of editDistance 3
68.101.
Usage of editDistance 4
68.102.
Usage of editDistance 5
68.103.
Usage of editDistance 6
68.104.
Usage of editDistance 7
68.105.
Usage of endsWith
68.106.
Usage of escapeUrl
68.107.
Usage of escapeUrlFragment
68.108.
Usage of find
68.109.
Usage of getAlphanumericChars
68.110.
Usage of getComponentProperty
68.111.
Usage of getFileExtension
68.112.
Usage of getFileName
68.113.
Usage of getFileNameWithoutExtension
68.114.
Usage of getFilePath
68.115.
Usage of getUrlHost
68.116.
Usage of getUrlPath
68.117.
Usage of getUrlPort
68.118.
Usage of getUrlProtocol
68.119.
Usage of getUrlQuery
68.120.
Usage of getUrlRef
68.121.
Usage of getUrlUserInfo
68.122.
Usage of indexOf
68.123.
Usage of isAscii
68.124.
Usage of isBlank
68.125.
Usage of isDate
68.126.
Usage of isDecimal
68.127.
Usage of isEmpty
68.128.
Usage of isInteger
68.129.
Usage of isLong
68.130.
Usage of isNumber
68.131.
Usage of isUnicodeNormalized
68.132.
Usage of isUrl
68.133.
Usage of isValidCodePoint
68.134.
Usage of join
68.135.
Usage of lastIndexOf
68.136.
Usage of left
68.137.
Usage of length
68.138.
Usage of lowerCase
68.139.
Usage of lpad
68.140.
Usage of matches
68.141.
Usage of matchGroups
68.142.
Usage of metaphone
68.143.
Usage of normalizePath
68.144.
Usage of NYSIIS
68.145.
Usage of randomString
68.146.
Usage of randomUUID
68.147.
Usage of removeBlankSpace
68.148.
Usage of removeDiacritic
68.149.
Usage of removeNonAscii
68.150.
Usage of removeNonPrintable
68.151.
Usage of replace
68.152.
Usage of reverse
68.153.
Usage of right
68.154.
Usage of rpad
68.155.
Usage of soundex
68.156.
Usage of split
68.157.
Usage of startsWith
68.158.
Usage of substring
68.159.
Usage of toProjectURL
68.160.
Usage of translate
68.161.
Usage of trim
68.162.
Usage of unescapeUrl
68.163.
Usage of unescapeUrlFragment
68.164.
Usage of unicodeNormalize
68.165.
Usage of upperCase
68.166.
Usage of getMappedSourceFields()
68.167.
Usage of getMappedTargetFields()
68.168.
Usage of isSourceFieldMapped()
68.169.
Usage of isTargetFieldMapped()
68.170.
Usage of append
68.171.
Usage of binarySearch
68.172.
Usage of clear
68.173.
Usage of clear
68.174.
Usage of containsAll
68.175.
Usage of containsKey
68.176.
Usage of containsValue
68.177.
Usage of copy
68.178.
Usage of copy
68.179.
Usage of getKeys
68.180.
Usage of getValues
68.181.
Usage of insert
68.182.
Usage of isEmpty
68.183.
Usage of isEmpty
68.184.
Usage of length:
68.185.
Usage of poll
68.186.
Usage of pop
68.187.
Usage of push
68.188.
Usage of remove
68.189.
Usage of reverse
68.190.
Usage of sort
68.191.
Usage of toMap
68.192.
Usage of compare
68.193.
Usage of copyByName
68.194.
Usage of copyByPosition
68.195.
Usage of getBoolValue
68.196.
Usage of getByteValue
68.197.
Usage of getDateValue
68.198.
Usage of DecimalValue
68.199.
Usage of getFieldIndex
68.200.
Usage of getFieldLabel
68.201.
Usage of getFieldName
68.202.
Usage of getFieldProperties
68.203.
Usage of getFieldType
68.204.
Usage of getIntValue
68.205.
Usage of getLongValue
68.206.
Usage of getNumValue
68.207.
Usage of getRecordProperties
68.208.
Usage of getStringValue
68.209.
Usage of getValueAsString
68.210.
Usage of isNull
68.211.
Usage of length
68.212.
Usage of resetRecord
68.213.
Usage of setBoolValue
68.214.
Usage of setByteValue
68.215.
Usage of setDateValue
68.216.
Usage of seDecimalValue
68.217.
Usage of setIntValue
68.218.
Usage of setLongValue
68.219.
Usage of setNumValue
68.220.
Usage of setStringValue
68.221.
Usage of getEnvironmentVariables()
68.222.
Usage of getJavaProperties()
68.223.
Usage of getParamValue
68.224.
Usage of getParamValues
68.225.
Usage of getRawParamValue
68.226.
Usage of getRawParamValues
68.227.
Usage of hashCode
68.228.
Usage of iif
68.229.
Usage of isnull
68.230.
Usage of nvl
68.231.
Usage of nvl2
68.232.
Sample property file
68.233.
Usage of parseProperties
68.234.
Usage of printErr
68.235.
Usage of printErr 2
68.236.
Usage of printLog
68.237.
Usage of raiseError
68.238.
Usage of resolveParams
68.239.
Usage of sleep
68.240.
Usage of toAbsolutePath
68.241.
Usage of count
68.242.
Usage of get
68.243.
Usage of next
68.244.
Usage of put
68.245.
Usage of Lookup Table Functions
68.246.
Usage of getSubgraphInputPortsCount
68.247.
Usage of getSubgraphOutputPortsCount
68.248.
Usage of isSubgraphInputPortConnected
68.249.
Usage of isSubgraphOutputPortConnected
68.250.
Usage of addResponseHeader
68.251.
Usage of containsResponseHeader
68.252.
Usage of getRequestBody
68.253.
Usage of getRequestClientIPAddress
68.254.
Usage of getRequestContentType
68.255.
Usage of getRequestEncoding
68.256.
Usage of getRequestHeader
68.257.
Usage of getRequestHeaderNames
68.258.
Usage of getRequestHeaders
68.259.
Usage of getRequestMethod
68.260.
Usage of getRequestParameter
68.261.
Usage of getRequestParameterNames
68.262.
Usage of getRequestParameters
68.263.
Usage of getRequestPartFilename
68.264.
Usage of getResponseContentType
68.265.
Usage of getResponseEncoding
68.266.
Usage of setRequestEncoding
68.267.
Usage of getResponseBody
68.268.
Usage of setResponseContentType
68.269.
Usage of setResponseEncoding
68.270.
Usage of setResponseHeader
68.271.
Usage of setResponseStatus