Table-of-Contents

Table of Contents

• 1 Introduction
• 2 Release Notes
  • Version 1.0
  • Version 1.1
  • Version 1.2
  • Version 1.3
  • Version 2.0
  • Version 2.1
  • Version 2.2
  • Version 2.3
  • Version 2.4
  • Version 2.5
  • Version 2.6
  • Version 2.7
  • Version 2.8
• 3 Installation and Settings
  • 3.1 Linux – RPM
  • 3.2 Linux – DEB
  • 3.3 Other Unix systems
  • 3.4 Settings
    • 3.4.1 Compiler
    • 3.4.2 Project
  • 3.5 Text Editor
    • 3.5.1 Vim
• 4 EVL Overview
  • 4.1 ETL in general
  • 4.2 EVL approach
  • 4.3 Terminology
  • 4.4 EVL Jobs
  • 4.5 EVL Workflows
  • 4.6 Scheduling
• 5 Main EVL Command
  • 5.1 Usage
  • 5.2 Examples
  • 5.3 Options
  • 5.4 Environment
  • 5.5 evl project
  • 5.6 evl run
  • 5.7 evl workflow
• 6 EVD and Data Types
  • 6.1 EVD Structure
    • 6.1.1 Comments
    • 6.1.2 Inline EVD
  • 6.2 EVD Options
    • 6.2.1 Separator Definition
    • 6.2.2 Null Option
    • 6.2.3 Quote Option
    • 6.2.4 Encoding and Locale
    • 6.2.5 Max string length
    • 6.2.6 QVD options
  • 6.3 Default Values
  • 6.4 Compound Types
    • 6.4.1 Vector
    • 6.4.2 Struct
  • 6.5 String
    • 6.5.1 Manipulation
    • 6.5.2 Search
    • 6.5.3 Comparison
    • 6.5.4 Numeric conversions
    • 6.5.5 EVL specific string functions
  • 6.6 Integral Types
  • 6.7 Decimal
    • 6.7.1 Declaration in mapping
    • 6.7.2 Manipulation, comparison
  • 6.8 Float and Double
  • 6.9 Date and Time
    • 6.9.1 Format string
    • 6.9.2 EVD Example
    • 6.9.3 Qlik’s time
    • 6.9.4 Qlik’s interval
    • 6.9.5 Declaration in mapping
    • 6.9.6 Manipulation, comparison
• 7 Components Common
  • 7.1 Common Options
• 8 Basic Components
  • 8.1 Assign
  • 8.2 Cat
  • 8.3 Cmd
  • 8.4 Component
  • 8.5 Cut
  • 8.6 Departition
  • 8.7 Echo
  • 8.8 Filter
  • 8.9 Gather
  • 8.10 Generate
  • 8.11 Head
  • 8.12 Lookup
  • 8.13 Merge
  • 8.14 Partition
  • 8.15 Sort
  • 8.16 Sortgroup
  • 8.17 Tail
  • 8.18 Tee
  • 8.19 Trash
  • 8.20 Uniq
  • 8.21 Validate
  • 8.22 Watcher
• 9 Mapping Components
  • 9.1 Aggreg
  • 9.2 Join
  • 9.3 Map
• 10 Read Components
  • 10.1 Read
  • 10.2 Readevd
  • 10.3 Readjson
  • 10.4 Readkafka
  • 10.5 Readmysql
  • 10.6 Readora
  • 10.7 Readparquet
  • 10.8 Readpg
  • 10.9 Readqvd
  • 10.10 Readsqlite
  • 10.11 Readtd
  • 10.12 Readxls
  • 10.13 Readxlsx
  • 10.14 Readxml
• 11 Run SQL Components
  • 11.1 Runmysql
  • 11.2 Runora
  • 11.3 Runpg
  • 11.4 Runsqlite
• 12 Write Components
  • 12.1 Write
  • 12.2 Writeevd
  • 12.3 Writejson
  • 12.4 Writekafka
  • 12.5 Writemysql
  • 12.6 Writeora
  • 12.7 Writeparquet
  • 12.8 Writepg
  • 12.9 Writeqvd
  • 12.10 Writeqvx
  • 12.11 Writesqlite
  • 12.12 Writetd
  • 12.13 Writexlsx
  • 12.14 Writexml
• 13 Commands
  • 13.1 Calendar
  • 13.2 Cancel
  • 13.3 Cp
  • 13.4 Chmod
  • 13.5 Crontab
  • 13.6 End
  • 13.7 Log
  • 13.8 Ls
  • 13.9 Mail
  • 13.10 Manager
  • 13.11 Mkdir
  • 13.12 Mv
  • 13.13 Project
  • 13.14 Rm
  • 13.15 Rmdir
  • 13.16 Run
  • 13.17 Set
  • 13.18 Skip
  • 13.19 Sleep
  • 13.20 Spark
  • 13.21 Status
  • 13.22 Test
  • 13.23 Touch
  • 13.24 Wait
• 14 EVM Mappings
  • 14.1 Output Functions
    • 14.1.1 discard and reject
    • 14.1.2 add_record and output
    • 14.1.3 unmatched_left, unmatched_right
    • 14.1.4 reject_left, reject_right
    • 14.1.5 warn and fail
  • 14.2 String Functions
    • 14.2.1 length
    • 14.2.2 split
    • 14.2.3 starts_with, ends_with
    • 14.2.4 str_compress, str_uncompress
    • 14.2.5 str_count
    • 14.2.6 str_index, str_rindex
    • 14.2.7 str_join
    • 14.2.8 str_mask_left, str_mask_right
    • 14.2.9 str_pad_left, str_pad_right
    • 14.2.10 str_replace
    • 14.2.11 str_index, str_rindex
    • 14.2.12 str_to_base64, base64_to_str
    • 14.2.13 str_to_hex, hex_to_str
    • 14.2.14 str_compress, str_uncompress
    • 14.2.15 substr
    • 14.2.16 trim, trim_left, trim_right
    • 14.2.17 uppercase, lowercase
  • 14.3 Date and Time Functions
  • 14.4 Randomization Functions
  • 14.5 Anonymization Functions
    • 14.5.1 anonymize
    • 14.5.2 anonymize_uniq
    • 14.5.3 anonymize_iban
  • 14.6 Encryption Functions
  • 14.7 Conversion Functions
    • 14.7.1 to_<type>
  • 14.8 IP Addresses Functions
    • 14.8.1 IPv4 Functions
    • 14.8.2 IPv6 Functions
  • 14.9 Logical Functions
    • 14.9.1 is_equal
    • 14.9.2 is_in
    • 14.9.3 is_valid_<type>
  • 14.10 Checksum Functions
  • 14.11 Mathematical Functions
  • 14.12 Lookup Functions
    • 14.12.1 index, index_range, index_all, get_<type>
    • 14.12.2 lookup_<type>
    • 14.12.3 lookup_range_<type>
  • 14.13 Other Functions
    • 14.13.1 first_not_null
    • 14.13.2 getenv_<type>
• 15 Joins and Lookups
  • 15.1 Lookup tables
    • 15.1.1 Declaration and load
    • 15.1.2 Methods
• 16 Utils
  • 16.1 csv2evd
  • 16.2 csv2qvd
  • 16.3 evd2sql
  • 16.4 guess-timestamp-format
  • 16.5 json2evd
  • 16.6 pg2evd
  • 16.7 qvd2csv
  • 16.8 qvd2evd
  • 16.9 evl_increment_run_id
  • 16.10 qvd-header
• EVM Functions Index
• EVD Data Types Index
• Variables Index
• General Index

---