Aperture Data Studio
Discussion List
-
Future Date Check 📅 (Dynamic)Summary This package contains 2x rules: “Is a future date” and “Not a future date” (compared to cur…
-
Convert Epoch Date/Time to Standard Date/Time ⌚Convert Epoch Date/Time to Standard Date/Time ⌚ This function was inspired by this post and created…
-
📣 Join us in person at our next UKI Data Management User Group I 9th March 2023 📅I am pleased to confirm that our next UK Data Management User Group will take place on Thursday 9 M…
-
Java pid hprof crash files.Facing the issue in our dev server for Aperture Data Studio and Find Duplicates. In log I have foun…
-
Java Update - Vulnerability detected on our Experian Dev/Prod ServerThis version has been detected as vulnerable by - OCPU-2022-JUL: Oracle Java Critical Patch Update …
-
Join us Online for our next Data Management User Group | 15 September 22 !I am pleased to confirm that our next UK Data Management User Group will take place on Thursday 15 …
-
Aperture Data Studio backups@Henry Simms , what would be the equivalent link to this according to current version. https://www…
-
Quick Actions menuSince v2.8 Aperture Data Studio has had a command palette that makes shortcuts and access to freque…
-
Challenge 5 – Fibonacci Sequence to XThe Fibonacci Sequence is the series of numbers 0, 1, 1, 2, 3, 5, 8, 13, 21, 34,.... The next numbe…
-
Does Aperture have the "treat leading zeros as alphanumeric" option that Pandora hadOne a a global setting that instructed Pandora to treat any input field with leading zeros as alph…
-
Repeating Characters 🔁Check for same character repeated This function uses a regular expression to identify records where…
-
How to copy dataset header to a row within the same dataset?Hello, I want to create an additional row on my dataset which would contain a copy of the header na…
-
Extract First Word 🥇📝This function extracts the first word in a string, in which all words are separated by space. The f…
-
Replace the word ‘NULL’ or any non-null space values with null 🔄👻This function replaces the word ‘Null’ (case insensitive) with a null value. For example, if the va…
-
Extract Last Word 💬🥉 Extract Last Word Version I This function extracts the last word in a string, in which all words a…
-
Challenge 5 SolutionsSo did you figure it out? What approach did you take? Something like this - what was your route to…
-
Aperture data studio log file locationHi, I have noticed something now in our prod servers. The log file generated for aperture data s…
-
Word FrequencyEvery now and then a scenario crops up where it'd handy to know how often a given word occurs withi…
-
Challenge 4 SolutionsSo did you figure it out? What approach did you take? You know what the results should look like, …
-
Parse Date 🧽📅Parse Date This function is designed to have flexibility to accommodate all sorts of different dat…
-
Huge HPROF file in installation folder.java_pid2376.hprof What is an HPROF file and what is it doing in my ADS installation folder. C:\Pro…
-
Challenge 4 - Cleaning product (data)Want to test your Aperture Data Studio skills a little more? This next challenge requires you to an…
-
Notifications based on emails in the dataWe have 50 service desks placing orders for customers around the country. We want to monitor those …
-
Low Disk Space Notifications and others.Hi team, this is to ask you if I create a low disk space notification on aperture data studio syst…
-
Calculate the distance between two sets of co-ordinates 🌍️ Summary Returns the approximate distance in kilometres between a pair of geographical co-ordinates.…
-
Force workflow failure due to failing rowsIs there a way I can force a whole workflow to fail as a result of failing rows in a validation ste…
-
Enabling LDAPIn case you haven't noticed, LDAP has been introduced since Aperture Data Studio v2.0.11. Go to Set…
-
Issue with dates being read as American datesI am pulling in my source data with a column that contains dates of the format dd/mm/yyyy. When ann…
-
Next ⏭️📅 & Previous ⏮️📅 Working DaySummary The 2x functions contained within this package relate to identifying the last working date …
-
Last day / working date of month 📅Summary The 2x functions contained within this package relate to identifying the last date of the m…
-
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…
-
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…
-
👋 Introduction to the Functions Library 📂Intro This area of the Community hosts our library of re-usable functions for use in Aperture Data …
-
👪 Parse Full NameSummary The functions contained within this package are all designed to help you in dealing with na…
-
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…
-
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…
-
Challenge 3 - It's a Date!This latest challenge is all about dates. The sample dataset highlights a common challenge many of …
-
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…