Use of Talend Open Studio for Data Quality:

[Anonymous]

¿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.

[Anonymous · Accepted solution]

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

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

Hi Sabrina,

Please, I was reading about feature Report, available in talend subscription solution but I found that I can only export the Analysis Results and not the set of data that match or no to a rule (valid and invalid rows in other cases. In Talend Open Studio for Data Quality I can export that set of data but only first 50 rows.

I need to export all data, is it possible to do in talend subscription solution?

Thanks.

[Anonymous]

Hello

We have replied to your another topic:https://community.talend.com/t5/Data-Quality-Preparation-and/Exporting-all-valid-or-invalid-rows-mat...

Please stick to one topic so that we can pay individule attention to your issue.

Best regards

Sabrina