December 2017
Beginner to intermediate
500 pages
12h 10m
English
You were just introduced to the basic editing features. Now we will create a new Transformation and put all that into practice. At the same time, you will learn to use new PDI steps.
The prerequisite for this exercise is to have a file with the source data. So, open your text editor, create a new file, and type the following:
project_name,start_date,end_dateProject A,2016-01-10,2016-01-25Project B,2016-04-03,2016-07-21Project C,2017-01-15,???Project D,2015-09-03,2015-12-20Project E,2016-05-11,2016-05-31Project F,2011-12-01,2013-11-30
Save the file as projects.csv and proceed with the PDI work.
This new Transformation will read the list of projects from the file, and then it will calculate the time ...
Read now
Unlock full access