Experian Data Quality Community
-
Censoring sensitive information within a dataset
I am attempting to censor sensitive information such as columns containing PII within a dataset based on user roles. Am I able to do this by attaching object tags to these specific columns within the dataset and restricting access based on the user roles? Or is there a better way of achieving this?
-
Distinct count aggregation
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
-
Strengthening Data Quality with ABN Validation
Hi DQ Community, I wanted to share some insights into the powerful custom workflow step for ABN (Australian Business Number Validation) within Experian’s Aperture Data Studio. Built using our SDK, this workflow step enables users to validate ABNs with a real-time API lookup against the ABR database. It not only confirms…
-
How to save profiling result as view for multiple table(50+ tables)
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.
-
Flattening out / Pivoting / Transforming results
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…
