Talend DQ define "Age" range profiling

Four Stars

Talend DQ define "Age" range profiling

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!

Moderator

Re: Talend DQ define "Age" range profiling

Hello,

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

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Talend DQ define "Age" range profiling

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"

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download