topic Re: Talend DQ define "Age" range profiling in Data Quality

Talend DQ define "Age" range profiling

Anonymous — Tue, 19 Sep 2017 14:04:21 GMT

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!

Re: Talend DQ define "Age" range profiling

Anonymous — Thu, 21 Sep 2017 10:53:47 GMT

Hello,

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

Best regards

Sabrina

Re: Talend DQ define "Age" range profiling

Anonymous — Thu, 21 Sep 2017 14:28:37 GMT

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"