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