In this tutorial we will work with a file that contains list of all French movies ever made. Each movie is described through several rows. This is how it looks like:
... 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 order to process the information of the file, it would be better if the rows belonging to each movie were merged into a single row. Let's work on that.
Download the file from the Packt website.
Create a transformation and read the file with a Text file input step.
In the Content tab of the Text file input step put
:
as separator. Also uncheck the Header and the No empty rows options.In the Fields tab enter two string fields—
feature
anddescription...