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 ...