Modules

Modules are the building blocks of a Loadit package. There are five types of modules as follows:

• Data Sources

  • Askia Interview Data
  • Excel Workbook

• Post Processing

  • Move File

• Pre Processing

  Post Processing modules execute after the main body of a Loadit package runs. They can be used to run supplementary tasks (e.g. send email, process OLAP cubes, run batch file) or perform cleanup tasks (e.g. run query, move file)

  • Run Application

• Transformations

  • Column Checks
  • Columns to Rows
  • Combine
  • Database Match
  • Deduplicate
  • Derived Columns
  • Join
  • Mapped Combine
  • Pivot
  • Randomise
  • Replace Text
  • Rows to Columns
  • Sort
  • Split
  • Translate Modalites
  • Transpose
  • Aggregate
  • Adjust Columns