Converting row data to column data using the Row denormaliser step

The Row denormaliser step converts the incoming dataset to a new dataset by moving information from rows to columns according to the values of a key field.

To understand how the Row denormaliser works, let's introduce an example. We will work with a file containing a list of French movies of all times. This is how it looks:

... Caché Year: 2005 Director: Michael Haneke Cast: Daniel Auteuil, Juliette Binoche, Maurice Bénichou  Jean de Florette Year: 1986 Genre: Historical drama Director: Claude Berri Produced by: Pierre Grunstein Cast: Yves Montand, Gérard Depardieu, Daniel Auteuil  Le Ballon rouge Year: 1956 Genre: Fantasy | Comedy | Drama ...

In the file, each movie is described ...

Get Learning Pentaho Data Integration 8 CE - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.