Best Of
-
Re: Aperture REST API calls as Datasets within Aperture
Hi @Mike Pearson You are right in saying that there is not currently a way to pull through the File Size data from the dataset endpoints, but there is a workaround you could try: You can run a comman…5 -
Re: Administration Space containing info on all objects
Here's some of the things I'd like to get from an "Admin" view: To help with scheduling maintenance / upgrades List of jobs actively running across environments List of users currently / re…5 -
Different date formats not being recognized as a date
What problem are you facing? Because the data is coming from many different sources the dates have different formats and when they are mixed up in one input it gets difficult to put them in the same …6 -
Auto discovery of keys (foreign, primary)
Logging this idea on behalf of @AlanB (feel free to add further commentary) What problem are you facing? We are starting a migration project from a largely undocumented system and need to identify ho…5 -
Bringing Data Together
Knowing the best path for working with multiple datasets can be confusing sometimes, understanding which approach is appropriate for what your wanting to achieve is key to getting the outcome you wan…5 -
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, th…6 -
Find Duplicates: handling of Gmail email modifiers
What problem are you facing? The Email and Email_Local elements in Find Duplicates Standardization currently retain all characters by default, including dots (.) and plus-aliases (+alias) in the loca…9 -
Add record limit to source step
What problem are you facing? Working with very large datasets, sometimes hundreds of millions of records, in order to debug a workflow, I often find myself adding a sample tool after each source so t…5 -
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 d…6 -
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 busine…7
