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…
-
Data Studio Salesforce ConnectionConnecting Data Studio directly to your data sources and CRM systems, like Salesforce, has never be…
-
ssl cert update process.has the process changed to update ssl cert on newer version? previously i used to do this, and hi…
-
📋 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…
-
👩💻 The HTTP Request (REST API) stepThis post is to raise awareness of an additional workflow step, that is increasingly being used to …
-
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 the s…
-
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…
-
📣 Join us at our next User Group - 9th November 2023 📅I am pleased to confirm that our next User Group event for Aperture Data Studio users will take pla…
-
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 telling…
-
Autonomous REST connection SQL queryHow can I get a simple SQL running when everything is set up . the Autonomous REST connection is su…
-
♻ Reusable workflow example – calculate word frequencyToday I’d like to share with you a reusable workflow that I built a little while ago not only as a …
-
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…
-
Want to pass certain input from API to the workflowi am trying to call an API from an external website my agenda is to pass some IDs that will be take…
-
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 attempting to delete match storeHi, In my project, we are using Experian Aperture Data Studio(2.10.10) to connect to a Remote Find …
-
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 …
-
Aperture Data Studio - Find Duplicate ServersHello Community, Our organization has recently decided to use ADS for Data Quality tool and we are …
-
Keyword: Community - Data Management User Group Material 09th March 2023It was great to meet the Experian Aperture Team and fellow users last week. Just wondering if and w…
-
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…
-
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…