Talend DQ define "Age" range profiling

[Anonymous]

Hello everyone!

I'd like to use Talend  DQ to profile a large data set I have. Now, I'd like to define range rules (i.e. age from 20- 25, 26-34, ...). How can I do this? 

Thanks a lot in advance!

[Anonymous]

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

[Anonymous]

Sure, Say I have an AGE column which has the following values:
5
7
6
10
20
26
21
22
46
34
50
55
53
Now I'd like to do column analysis not on the exact numbers above, but in terms on range like
3 ">=50"
5 "<=20"
5 ">20 - <50"