Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Hi, I have a table showing customers, their current statuses, and when those statuses take effect. As customers can have more than one status, we have duplicate customer IDs. I need to merge the statuses into one row, separated by a forward slash, so that each customer ID is unique. Can this be done in a workflow?
I am not sure how to apply distinct count as aggregation while do group by ? There is check box "distinct", even though i enable that still does not give distinct count. Can someone help me to apply distinct count as aggregation in group by
Hello! I’ve been using the built-in validation rules in Aperture (like validate telephone, email, and address), and I really like how they generate a RAG-style column to show data quality at a glance. I’m now looking to create my own custom RAG status based on specific business rules for example, combining multiple fields…
I have many tables, i need to run profiling on each of the tables and need to save the results as view. Since i have more number of tables, is there any way to do this altogether, rather then doing the same thing each table one by one.
Hi, I'm having an issue flattening out results. Essentially, I have multiple rows for the same customer because they have different PII's. Is there any way of transforming / pivoting / flattening out the results to have one row for each customer? I have left a screenshot of mock-up data below to help people understand. I…
