The Database lookup step is very useful and quite simple, but it is quite limited. Taking as an example our Pagila database, suppose that you want to do the following lookups:
- You want to look for films with a given category, for example, Comedy. In our database, the films and the category names are in different tables. As the Database Value Lookup works with a single table, it's not suitable for this search.
- You want to look for films where the name contains the word, House. You can do this search with a Database Value Lookup step but the step will return maximum one film, even if there are more in the films table containing that word.
- You want to look for an actor whose name or the last name begins with ...