Hi Team,
I am working on task to check the number of rows in a column. I am using count of ATTRIBUTE_1 but not able to achieve it . can you please suggest a better approach. let me know if i miss anything.
Solved
row count in a column
- Data Pioneer
Best answer by srija piratla
Hi
To check the number of rows in a column based on a dq rule. Please remove the attribute1 in the group by condition. This way it works.
I attached this DQ rule to monitoring project and ran it.
Note - If you include attribute1 in the group by condition it will consider count of the attribute value instead of row.
Hope this helps.
Regards,
Srija Piratla
- Ataccamer
- Answer
Hi
To check the number of rows in a column based on a dq rule. Please remove the attribute1 in the group by condition. This way it works.
I attached this DQ rule to monitoring project and ran it.
Note - If you include attribute1 in the group by condition it will consider count of the attribute value instead of row.
Hope this helps.
Regards,
Srija Piratla
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.