Aperture Data Studio
Discussion List
-
How to promote from dev to prod environments when using different external systemsProblem: I’ve recently been working with a client who had used their Data Studio development enviro…
-
Relationship Discovery by using Find Duplicates Step in Aperture Data StudioWe tried to find the join candidates across tables and databases by using the profiling metadata in…
-
Repeating Characters 🔁Check for same character repeated This function uses a regular expression to identify records where…
-
Dynamic Naming of Output FileHi, Is it possible to have a dynamic text element of the naming of an output file. I understand th…
-
Error with resuable workflow step in new workflowHi, I have created a workflow that produces an output and has been made reuseable. This workflow i…
-
Standardise Country 🌎Standardise Country The function uses reference data (contained within the .dmxd file) to standardi…
-
👋 Introduction to the Functions Library 📂Intro This area of the Community hosts our library of re-usable functions for use in Aperture Data …
-
Create our own Elements for Find Duplicates StepHi Team, I'd like to ask some questions about Find Duplicates Step. Is this step only for CONTACT …
-
Questions about Data Tagging and Profiling in Aperture Data StudioHi team, Is it possible to tag and profile multiple tables at the same time in Aperture Data Studio…
-
Parameters for Source Step in Aperture Data Studio WorkflowHi Team, We want to use the API to run a workflow iteratively using different source datasets (we …
-
Searching for metadata in the UI (e.g from datasets view or others)Hi, I'm working on a data discovery project that needs to identify the best sources of critical dat…
-
👪 Parse Full NameSummary The functions contained within this package are all designed to help you in dealing with na…
-
Introducing the new Functions Library - fast track your time to value with Data Studio!The Functions Library is a collection of free, reusable content for you to instantly download and u…
-
📋 Index of reusable Functions! 📇This post simply acts as an index for all the functions shared in this library. If you would like t…
-
Offensive Words 🤬Summary The functions contained within this package all relate to flagging and dealing with data co…
-
Mask Out Email/Phone 🛡️Summary This package contains 2x functions to help with anonymising certain input values, whilst le…
-
Proper Case Surname 📛Summary This package contains 2x functions which help with contact data: Proper Case Surname and Va…
-
Job Title Match Key 👨💼👩💼Job Title Match Key The function in this post has been designed to help illustrate an approach (and…
-
Invalid Character for Names ☹️Summary This package contains 2x functions: Contains Only Valid Characters for Names & Contains…
-
Compare Dates (Verbose) 📅📅Compare Dates (Verbose) [Category: Conversion] This function provides a summary of how 2x input dat…
-
Convert Boolean ✅❌Convert Boolean [Category: Conversion] This function converts a binary or Boolean values (i.e. true…
-
Contains Non-Latin Characters 🈯Contains Non-Latin Characters [Validation] This function identifies the presence of any characters …
-
Reverse String ⏪Reverse String If you find yourself needing to reverse a string (i.e. for bespoke building of anony…
-
PCI Detection 💳 (Payment Card Information)Summary The following package is used to detect payment card information (PCI) and whether it is pr…
-
SIC Conversion 🏷️Summary The following package is used in processing Standard Industry Classification (SIC) codes, a…
-
Future Date Check 📅 (Dynamic)Summary This package contains 2x rules: “Is a future date” and “Not a future date” (compared to cur…
-
Connecting to a SAP HANA database using Data StudioFrom the Data Studio v1.6.1 release onwards, we've made it easier to connect to a SAP HANA database…
-
SAML anyone?Hi everyone. Our engineering team is currently working on a feature for Single sign on enterprise …
-
Sharing of useful functions to support contact data validationHi all, I've found myself using a few functions on a regular basis so thought I'd share them on her…
-
Where could I find more information on how to use "Query duplicates store"?Hi, I am new to Aperture Data studio and one of my recent requirement is to use a supplied contact …
-
Sign up to the latest data quality webinar "How to eliminate poor CRM customer contact data"Hi all, Experian is holding a free webinar on “How to eliminate the impact of poor CRM customer co…
-
How to setup Google Big Query as an external system for pushing data into BigQuery tableHi, Did anybody try using the Google Big Query 6.0 JDBC and know how to configure the credential de…
-
Attention all V1 & V2 users...Today we have launched a new sub category, Migrating from V1 to V2, which contains posts to aid you…