Aperture Data Studio
Discussion List
-
Managing Data Quality issues using Issue listsIssue lists allows Users in the same Space (including read-only Consumer users) to capture problema…
-
Compare two data sourcesThe Compare step allows you to detect and highlight differences between two data sources, e.g. year…
-
📋 Index of reusable Functions! 📇This post simply acts as an index for all the functions shared in this library. If you would like t…
-
Business Validation and EnrichmentAperture is a powerful tool when validating business information you already have. We can leverage …
-
UK Postcode formatter 🏡Summary This package contains a single function but may be updated in the future to include others.…
-
🔎 Data profiling showcaseEver since Aperture Data Studio’s pre-curser, Pandora, one of our most used features and most loved…
-
Aperture Data Studio 2.12.8, Find Duplicates 3.9.1We upgraded today our prod servers, and now we have the same situation, settings in find duplicates…
-
🦸♂️ Data Management User Group event summaryLast week we welcomed over 40 customers to our latest Data Quality User Group. Held in our London o…
-
Use of If-Then-Else logic in Aperture Data StudioImagine you are asked to use Aperture Data Studio to generate a new field for your sales data. You…
-
Documenting what data is available in Data Studio (to users who don't have access)A question that cropped up earlier today was: 'how can we avoid different users connecting to …
-
Upgrade Issue, Aperture data studio , Find Duplicates latest versionsHi Ian, Looks like after the recent upgrade we have an issue that experianmatch path got changed t…
-
Low Disk Space issue.Hi, We have the disk space issue once more for our data drive. We changed the index expiry setting…
-
Standardise Country 🌎Standardise Country The function uses reference data (contained within the .dmxd file) to standardi…
-
Workflow is not in an executable state but no errors existHi DQ Community, I have a workflow that I can't run or publish because I get error messages te…
-
Autonomous REST connection SQL queryHow can I get a simple SQL running when everything is set up . the Autonomous REST connection is su…
-
Handling data from Experian Aperture Data Studio jobsWe are getting error in the execution of Experian scheduled jobs as "There is not enough spac…
-
How is true / false field stored in Aperture?Note that the data below is business data and not PII. Issue: When I import the CSV file created in…
-
Copy of FiServ Files uploaded into DA & use of the Metro2 ParserDoes anyone use Data Arc with a copy of a FiServ Metro2 File? We are setting this up as net new an…
-
Stored Procedure invoked from PostSQL of Export step is not processing all recordshi, In my workflow, I am connecting to SQL server 2012 using Custom JDBC jar (Microsoft JDBC Jar 12…
-
Date formats...Earlier today I received the below email from a customer which I wanted to post on here in case the…
-
Error while connecting to Embedded Duplicate StoreHi, I am getting error as below when I am trying to connect to the Embedded Duplicate store in my D…
-
Error while invoking stored procedure from Experian Aperture Data Studio using custom JDBC driverHi, I am using the Experian Aperture Data Studio (2.10.0.80) and have configured a custom JDBC Jar …
-
shutdown due to heartbeat?2023-04-13 08:57:06,646 INFO c.e.d.b.BatchService [Thread-0] Shutdown due to heartbeat timeout 202…
-
ADS, not enough permissions for page.user is admin to the workspace. what could possibly be the reason for her not to see the dashboard …
-
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 create…
-
📣 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…
-
Repeating Characters 🔁Check for same character repeated This function uses a regular expression to identify records where…
-
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…
-
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…
-
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…
-
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…
-
👋 Introduction to the Functions Library 📂Intro This area of the Community hosts our library of re-usable functions for use in Aperture Data …