topic Re: Use of Talend Open Studio for Data Quality: in Data Quality

Use of Talend Open Studio for Data Quality:

Anonymous — Mon, 27 Nov 2017 17:32:58 GMT

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

Re: Use of Talend Open Studio for Data Quality:

Anonymous — Wed, 29 Nov 2017 06:33:19 GMT

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

Re: Use of Talend Open Studio for Data Quality:

Anonymous — Wed, 29 Nov 2017 15:50:07 GMT

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?

Re: Use of Talend Open Studio for Data Quality:

Anonymous — Thu, 30 Nov 2017 02:36:49 GMT

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

Re: Use of Talend Open Studio for Data Quality:

Anonymous — Tue, 19 Dec 2017 17:45:41 GMT

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.

Re: Use of Talend Open Studio for Data Quality:

Anonymous — Fri, 22 Dec 2017 06:42:11 GMT

Hello

We have replied to your another topic:https://community.talend.com/t5/Data-Quality-Preparation-and/Exporting-all-valid-or-invalid-rows-match-or-not-match-rows-from/m-p/45602/highlight/false#M1294

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

Best regards

Sabrina