Pentaho: add another column based on another column

Question

I have this situation, I have data about age, and I want to add another column, with age range:

Range 1 (0-18 years) = children;
Range 2 (19-50) = adults;
Range 3 (50+) older people

How can I do this in Pentaho? I have already tried it with filters and so on, but I didn't success. So I want to have an output shown on picture below (for about 100k rows, so i can't do it manually).

Target data [AgeRang column added]:

score 2 · Accepted Answer · answered Jan 04 '18 at 11:10

2

The step you are looking for is named Number range.

answered Jan 04 '18 at 11:10

AlainD

6,187
3
17
31

score 0 · Answer 2 · answered Jan 04 '18 at 09:04

I would use a step called User Defined Java Expression which filters data using Java expression and adds new column age_range to record stream's row.

Use this statement in Java expression field:

(age <= 18) ? 1 : (age <= 50) ? 2 : 3

Check following figure from execution:

Pentaho: add another column based on another column

2 Answers2