How to
Check whether the target column has only DATE values or not.
?
Solved
Need DQ Rule
- Data Pioneer
- 33 replies
Best answer by anna.spakova
Hello
From the DQ rules perspective, you can write rules that will check if the values are e.g. only numbers (example would be to use trashNonDigits function and compare to the original value) etc., but I can imagine this can get pretty complicated for DATE as you can have different date formats. You may need to use some regex expressions… Also important is to keep in mind that the rule can get assigned only to the attribute with the corresponding data type as the input attribute of the rule (so if you have an INTEGER column, you are not able to assign rule with STRING as an input attribute).
1 person likes this
+3- Ataccamer
- 144 replies
Hi,
if you have the data with the column (Catalog Item) in a catalog, you can check the profiling results to see what the data in the column look like.
Does that answer your question?
- Data Pioneer
- 33 replies
Hello
+3- Ataccamer
- 144 replies
- Answer
Hello
From the DQ rules perspective, you can write rules that will check if the values are e.g. only numbers (example would be to use trashNonDigits function and compare to the original value) etc., but I can imagine this can get pretty complicated for DATE as you can have different date formats. You may need to use some regex expressions… Also important is to keep in mind that the rule can get assigned only to the attribute with the corresponding data type as the input attribute of the rule (so if you have an INTEGER column, you are not able to assign rule with STRING as an input attribute).
- Data Pioneer L2
- 31 replies
You can assoicate a term to this column and have DQ rules associated to TERM, this will ensure the underlying rule is executed whenever you reprofile and validate dq evaluation results
Reply
Most Liked this week
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.