Four Stars

Use of Talend Open Studio for Data Quality:

¿Is it possible to evaluate the content of a column based on the content of another column in any table, not necessarily foreing keys or columns of same name in different tables?.  Addicionally, ¿can we applicate regular expressions to evaluate some of these columns?

 

For example:  If the value of column A of table T1 is equal to 'SOME_VALUE' then evaluate that column B of table T2 is grater than '10'.

 

Thankyou.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

Re: Use of Talend Open Studio for Data Quality:

Hello,

Could you please have a look at column analyses feature in talend open studio for data quality to see if it is what you are looking for?

TalendHelpCenter:Column analyses

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.
3 REPLIES
Moderator

Re: Use of Talend Open Studio for Data Quality:

Hello,

Could you please have a look at column analyses feature in talend open studio for data quality to see if it is what you are looking for?

TalendHelpCenter:Column analyses

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: Use of Talend Open Studio for Data Quality:

Thakyou Sabrina.

 

I have reviewed the topic about column analyses features and I think that we could couple and apply to get a satisfactory result.

 

So, please I have a new question to do about the analsys results: ¿can I export, in an automatic way, this results in a database table or in a text file? ¿Should I put this question in another post?

Moderator

Re: Use of Talend Open Studio for Data Quality:

Hi,

Do you want to export data analysis result? If so, the "Report" feature will be available in talend subscription solution for data quality product.

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.