Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
¿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.
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
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
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?
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
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.
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