Home | CloverETL Designer | CloverETL 4.6.1
--- | --- | ---

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
48.1. Example State Function
48.2.
48.3. Generating Variable Number of Records in CTL
48.4. Example Mapping in JavaBeanReader
48.5. Reading lists with JavaBeanReader
48.6. Mapping in XMLExtract
48.7. From XML Structure to Mapping Structure
48.8. Mapping in XMLReader
48.9. Reading lists with XMLReader
48.10. Mapping in XMLXPathReader
49.1. Examples of Queries
49.2. Creating Binding
49.3. Creating Binding
49.4. Writing arrays
49.5. Creating Binding
49.6. Writing arrays
49.7. Example of a Control script
49.8. Writing Excel format
49.9. Writing hyperlinks
49.10. Using Expressions in Ports and Fields
49.11. Include and Exclude property examples
49.12. Attribute value examples
49.13. Writing null attribute
49.14. Omitting Null Attribute
49.15. Hide Element
49.16. Partitioning According to Any Element
49.17. Writing and omitting blank elements
49.18. Binding that serves as JOIN
49.19. Insert Wildcard attributes in Source tab
50.1. Join Key for DataIntersection
50.2. Key for Denormalizer
51.1. Join Key for DBJoin
51.2. Slave Part of Join Key for ExtHashJoin
51.3. Join Key for ExtHashJoin
51.4. Join Key for ExtMergeJoin
51.5. Join Key for LookupJoin
51.6. Join Key for RelationalJoin
56.1. CTL Mapping and multipart entities
56.2. Working with Quoted Command Line Arguments
56.3. Use nested nodes example
57.1. Join Key for ApproximativeJoin
57.2. Matching Key
58.1. Example of CTL2 code
59.1. Example of CTL2 syntax (Rollup)
59.2. Example of an import of a CTL file
59.3. Example of an import of a CTL file with a graph parameter
59.4. Declaration of boolean variable
59.5. Declaration of byte variable
59.6. Declaration of cbyte variable
59.7. Declaration of date variable
59.8. Usage of decimal data type in CTL2
59.9. Declaration of decimal variable
59.10. Declaration of integer variable
59.11. Declaration of long variable
59.12. Declaration of number (double) variable
59.13. Declaration of string variable
59.14. List
59.15. Map
59.16. Variables
59.17. Compound assignment operators
59.18. Modification of a copied list, map and record
59.19. If statement
59.20. Switch statement
59.21. For loop
59.22. Mapping of Metadata by Name (using the copyByName() function)
59.23. Mapping of Metadata by Position
59.24. Example of Mapping with Individual Fields
59.25. Example of Mapping with Wild Cards
59.26. Example of Mapping with Wild Cards in Separate User-Defined Functions
59.27. Regular Expressions Examples
61.1. Usage of base64byte
61.2. Usage of bits2str
61.3. Usage of bool2num
61.4. Usage of byte2base64
61.5. Usage of byte2hex
61.6. Usage of byte2str
61.7. Usage of date2long
61.8. Usage of date2num
61.9. Usage of date2str
61.10. Usage of decimal2double
61.11. Usage of decimal2integer
61.12. Usage of decimal2long
61.13. Usage of double2integer
61.14. Usage of double2long
61.15. Usage of hex2byte
61.16. Usage of json2xml
61.17. Usage of long2date
61.18. Usage of long2integer
61.19. Usage of long2packDecimal
61.20. Usage of md5
61.21. Usage of num2bool
61.22. Usage of num2str
61.23. Usage of packDecimal2long
61.24. Usage of sha
61.25. Usage of sha256
61.26. Usage of str2bits
61.27. Usage of str2bool
61.28. Usage of str2byte
61.29. Usage of str2date
61.30. Usage of str2decimal
61.31. Usage of str2double
61.32. Usage of str2integer
61.33. Usage of str2long
61.34. Usage of toString
61.35. Usage of xml2json
61.36. Usage of createDate
61.37. Usage of dateAdd
61.38. Usage of dateDiff
61.39. Usage of extractDate
61.40. Usage of extractTime
61.41. Usage of getYear
61.42. Usage of getMonth
61.43. Usage of getDay
61.44. Usage of getHour
61.45. Usage of getMinute
61.46. Usage of getSecond
61.47. Usage of getMillisecond
61.48. Usage of randomDate
61.49. Usage of today
61.50. Usage of abs
61.51. Usage of acos
61.52. Usage of asin
61.53. Usage of atan
61.54. Usage of bitAnd
61.55. Usage of bitIsSet
61.56. Usage of bitLShift
61.57. Usage of bitNegate
61.58. Usage of bitOr
61.59. Usage of bitRShift
61.60. Usage of bitSet
61.61. Usage of bitXor
61.62. Usage of ceil
61.63. Usage of cos
61.64. Usage of e
61.65. Usage of exp
61.66. Usage of floor
61.67. Usage of log
61.68. Usage of log10
61.69. Usage of max
61.70. Usage of min
61.71. Usage of pi
61.72. Usage of pow
61.73. Usage of random
61.74. Usage of randomBoolean
61.75. Usage of randomGaussian
61.76. Usage of randomInteger
61.77. Usage of randomLong
61.78. Usage of round
61.79. Usage of roundHalfToEven
61.80. Usage of setRandomSeed
61.81. Usage of signum
61.82. Usage of sin
61.83. Usage of sqrt
61.84. Usage of tan
61.85. Usage of toDegrees
61.86. Usage of toRadians
61.87. Usage of byteAt
61.88. Usage of charAt
61.89. Usage of chop
61.90. Usage of codePointAt
61.91. Usage of codePointLength
61.92. Usage of codePointToChar
61.93. Usage of concat
61.94. Usage of concatWithSeparator
61.95. Usage of contains
61.96. Usage of countChar
61.97. Usage of cut
61.98. Usage of editDistance 1
61.99. Usage of editDistance 2
61.100. Usage of editDistance 3
61.101. Usage of editDistance 4
61.102. Usage of editDistance 5
61.103. Usage of editDistance 6
61.104. Usage of editDistance 7
61.105. Usage of endsWith
61.106. Usage of escapeUrl
61.107. Usage of escapeUrlFragment
61.108. Usage of find
61.109. Usage of getAlphanumericChars
61.110. Usage of getComponentProperty
61.111. Usage of getFileExtension
61.112. Usage of getFileName
61.113. Usage of getFileNameWithoutExtension
61.114. Usage of getFilePath
61.115. Usage of getUrlHost
61.116. Usage of getUrlPath
61.117. Usage of getUrlPort
61.118. Usage of getUrlProtocol
61.119. Usage of getUrlQuery
61.120. Usage of getUrlRef
61.121. Usage of getUrlUserInfo
61.122. Usage of indexOf
61.123. Usage of isAscii
61.124. Usage of isBlank
61.125. Usage of isDate
61.126. Usage of isDecimal
61.127. Usage of isEmpty
61.128. Usage of isInteger
61.129. Usage of isLong
61.130. Usage of isNumber
61.131. Usage of isUnicodeNormalized
61.132. Usage of isUrl
61.133. Usage of isValidCodePoint
61.134. Usage of join
61.135. Usage of lastIndexOf
61.136. Usage of left
61.137. Usage of length
61.138. Usage of lowerCase
61.139. Usage of lpad
61.140. Usage of matches
61.141. Usage of matchGroups
61.142. Usage of metaphone
61.143. Usage of normalizePath
61.144. Usage of NYSIIS
61.145. Usage of randomString
61.146. Usage of randomUUID
61.147. Usage of removeBlankSpace
61.148. Usage of removeDiacritic
61.149. Usage of removeNonAscii
61.150. Usage of removeNonPrintable
61.151. Usage of replace
61.152. Usage of reverse
61.153. Usage of right
61.154. Usage of rpad
61.155. Usage of soundex
61.156. Usage of split
61.157. Usage of startsWith
61.158. Usage of substring
61.159. Usage of toProjectURL
61.160. Usage of translate
61.161. Usage of trim
61.162. Usage of unescapeUrl
61.163. Usage of unescapeUrlFragment
61.164. Usage of unicodeNormalize
61.165. Usage of upperCase
61.166. Usage of getMappedSourceFields()
61.167. Usage of getMappedTargetFields()
61.168. Usage of isSourceFieldMapped()
61.169. Usage of isTargetFieldMapped()
61.170. Usage of append
61.171. Usage of binarySearch
61.172. Usage of clear
61.173. Usage of clear
61.174. Usage of containsAll
61.175. Usage of containsKey
61.176. Usage of containsValue
61.177. Usage of copy
61.178. Usage of copy
61.179. Usage of getKeys
61.180. Usage of getValues
61.181. Usage of insert
61.182. Usage of isEmpty
61.183. Usage of isEmpty
61.184. Usage of length:
61.185. Usage of poll
61.186. Usage of pop
61.187. Usage of push
61.188. Usage of remove
61.189. Usage of reverse
61.190. Usage of sort
61.191. Usage of toMap
61.192. Usage of compare
61.193. Usage of copyByName
61.194. Usage of copyByPosition
61.195. Usage of getBoolValue
61.196. Usage of getByteValue
61.197. Usage of getDateValue
61.198. Usage of DecimalValue
61.199. Usage of getFieldIndex
61.200. Usage of getFieldLabel
61.201. Usage of getFieldName
61.202. Usage of getFieldProperties
61.203. Usage of getFieldType
61.204. Usage of getIntValue
61.205. Usage of getLongValue
61.206. Usage of getNumValue
61.207. Usage of getRecordProperties
61.208. Usage of getStringValue
61.209. Usage of getValueAsString
61.210. Usage of isNull
61.211. Usage of length
61.212. Usage of resetRecord
61.213. Usage of setBoolValue
61.214. Usage of setByteValue
61.215. Usage of setDateValue
61.216. Usage of seDecimalValue
61.217. Usage of setIntValue
61.218. Usage of setLongValue
61.219. Usage of setNumValue
61.220. Usage of setStringValue
61.221. Usage of getEnvironmentVariables()
61.222. Usage of getJavaProperties()
61.223. Usage of getParamValue
61.224. Usage of getParamValues
61.225. Usage of getRawParamValue
61.226. Usage of getRawParamValues
61.227. Usage of hashCode
61.228. Usage of iif
61.229. Usage of isnull
61.230. Usage of nvl
61.231. Usage of nvl2
61.232. Sample property file
61.233. Usage of parseProperties
61.234. Usage of printErr
61.235. Usage of printErr 2
61.236. Usage of printLog
61.237. Usage of raiseError
61.238. Usage of resolveParams
61.239. Usage of sleep
61.240. Usage of toAbsolutePath
61.241. Usage of count
61.242. Usage of get
61.243. Usage of next
61.244. Usage of put
61.245. Usage of Lookup Table Functions
61.246. Usage of getSubgraphInputPortsCount
61.247. Usage of getSubgraphOutputPortsCount
61.248. Usage of isSubgraphInputPortConnected
61.249. Usage of isSubgraphOutputPortConnected

| Home |