Functions

Discussion List

• 👪 Parse Full Name

  Summary The functions contained within this package are all designed to help you in dealing with na…

  36 views 0 comments 0 points Started by Danny Roden January 22 Functions Library
• 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…

  Pinned post 79 views 0 comments 4 points Started by Tanj Jagpal January 22 General discussion
• 📋 Index of reusable Functions! 📇

  This post simply acts as an index for all the functions shared in this library. If you would like t…

  Pinned post Read only 275 views 2 comments 6 points Most recent by Danny Roden December 2020Functions Library
• Offensive Words 🤬

  Summary The functions contained within this package all relate to flagging and dealing with data co…

  37 views 0 comments 0 points Started by Danny Roden December 2020 Functions Library
• Standardise Country 🌎

  Standardise Country The function uses reference data (contained within the .dmxd file) to standardi…

  65 views 0 comments 0 points Started by Danny Roden December 2020 Functions Library
• Mask Out Email/Phone 🛡️

  Summary This package contains 2x functions to help with anonymising certain input values, whilst le…

  25 views 0 comments 0 points Started by Danny Roden December 2020 Functions Library
• Proper Case Surname 📛

  Summary This package contains 2x functions which help with contact data: Proper Case Surname and Va…

  25 views 0 comments 0 points Started by Danny Roden December 2020 Functions Library
• Job Title Match Key 👨‍💼👩‍💼

  Job Title Match Key The function in this post has been designed to help illustrate an approach (and…

  36 views 0 comments 0 points Started by Danny Roden December 2020 Functions Library
• 👋 Introduction to the Functions Library 📂

  Intro This area of the Community hosts our library of re-usable functions for use in Aperture Data …

  Pinned post 73 views 0 comments 1 point Started by Danny Roden November 2020 Functions Library
• Sharing of useful functions to support contact data validation

  Hi all, I've found myself using a few functions on a regular basis so thought I'd share them on her…

  123 views 3 comments 3 points Most recent by Juha Ritvas October 2020General discussion
• Function to calculate the number of working days between two dates

  Recently I wanted to create a function in Data Studio to calculate the number of working days betwe…

  643 views 1 comment 2 points Most recent by Henry Simms June 2020General discussion
• Duplicate Match Status Converter

  This is not a difficult thing to do but is a bit time consuming. Find Duplicates Match status is nu…

  43 views 0 comments 1 point Started by Chris Downer June 2020 General discussion
• How to systematically sample with a fixed sample size and varying population size

  I was recently asked how to build a Data Studio workflow that would output a systematically sampled…

  67 views 2 comments 2 points Most recent by Henry Simms May 2020General discussion
• Extracting a specific piece of information from an address using regular expressions and lookups

  Data Studio has several built-in functions to allow you parse strings of text and extract a particu…

  737 views 3 comments 2 points Most recent by Clinton Jones October 2019General discussion
• Getting started with Regular Expressions in Data Studio

  A regular expression (from here on we’ll call them “regex” for short) is a well-known and powerful …

  166 views 3 comments 7 points Most recent by Henry Simms September 2019General discussion