ETL File

Read(759) Label: etl,

This section illustrates how to create and use ETL files.

An ETL file defines some operations. It extracts data from a database able or a txt/csv/xls/xlsx/btx file, adds a computed column or performs filtering, sorting, grouping & aggregation, set operations and joins or retrieves certain fields, and finally, exports result set to a ctx/btx/txt/csv/xlsx file or a database table.