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