For the complete documentation index, see llms.txt. This page is also available as Markdown.
Lookups
Introduction
Besides transforming the data, you may need to search and bring data from other sources. Let us look at the following examples:
You have some product codes and you want to look for their descriptions in an Excel file
You have a value and want to get all products whose price is below that value from a database
Searching for information in databases, text files, web services, and so on, is a very common task, and Kettle has several steps for doing it.
Lookup / List tables
For instance, if your database is about sales, you probably have a Customers table and an Orders table, each with its own attributes resolved through a Foreign Key. The lookup tables are usually very small, with just a handful of rows in them.
