Chapter 5

finding the seven errors

1

The type of log a doesn't exist. Look at the sample provided for the function to see the valid options.

The variable uSkill is not defined. Its definition is required if you want to add it to the list of new fields.

setValue() cause an error without compatibility mode. To change the value of the Country field, a new variable should be used instead.

A variable named average is calculated but wAverage is used as the new field.

It is not trans_status; it is trans_Status.

No data type was specified for the totalScore field.

The sentence writeToLog(‘Ready to calculate averages...') will be written for every row. To write it at the beginning, you have to put it in a Start script, not in the main.

Get Pentaho 3.2 Data Integration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.