Lookups
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.
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.
Last updated
