Experian Data Quality Community
-
Word Frequency
Every now and then a scenario crops up where it'd handy to know how often a given word occurs within a given dataset. For example you're profiling a reasonably standardised list of values (e.g. job titles) and you want to identify unusually common terms (like 'manager' 'executive' etc) or infrequent ones (like 'test123').…
-
Group Step Sum of Nulls should return Null
What problem are you facing? When getting the Sum of a column via a Group Step, if all the values considered in the aggregation are Null, the Sum presently returns zero. This makes it impossible to distinguish whether all the values were Null or if the data contained numbers with a sum of zero. This distinction may matter.…
-
Determine the minimum numeric value when column contains null/string values
What problem are you facing? The "minimum" aggregate returns null() as the minimum if at least one of the values in a column are empty. What impact does this problem have on you/your business? This impacts data quality and returns incorrect results for aggregates when dealing with numeric values. Do you have any existing…
-
Group Step > Being able to select and right click view multiple rows in groups
What problem are you facing? When the Group step is used, we can only view rows in group on one value. What impact does this problem have on you/your business? Feedback received of this not being user friendly and having to exit the screen to be able to get to the multiple filtered values. Do you have any existing…
-
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…
