Aperture Data Studio

Discussion List

• UK Postcode check

  Hi, I have a requirement where I receive a csv file with postcode(no other address fields is provi…

  Answered 20 views 1 comment 0 points Most recent by Henry Simms March 26General
• ssl cert update process.

  has the process changed to update ssl cert on newer version? previously i used to do this, and hi…

  Answered ✓ 145 views 12 comments 0 points Most recent by HussainSyed March 11Administration
• 5
  Group Step > Being able to select and right click view multiple rows in groups

  What problem are you facing? When the Group step is used, we can only view rows in group on one va…

  Now available 95 views 2 comments 5 points Most recent by Henry Simms February 12Ideas board
• Kill Dataset refresh job via API

  hi, I am performing bulk data profiling on datasets using API automation where my steps are as belo…

  Answered 21 views 3 comments 0 points Most recent by Josh Boxer January 24General
• Delimited csv file creation using Export step

  Hi, We are using Experian Aperture Data Studio version 2.14.14.40 and have changed the settings to …

  Answered 43 views 3 comments 0 points Most recent by Henry Simms January 13General
• Performance

  We have just stood up a new server that is the same spec as our old server but has a slightly new v…

  Answered 33 views 2 comments 0 points Most recent by HenrySykes December 2024Administration
• Adding Microsoft SQL Server to an ADS server

  Has anybody got any experience in having Microsoft SQL Server and data tools installed on the same …

  Answered 31 views 2 comments 0 points Most recent by Henry Simms November 2024Support
• Your API key < API key name > will expire in 10 days'

  can u help me set up this? i cannot find the right directives in below documentation. i need to k…

  21 views 2 comments 0 points Most recent by HussainSyed November 2024Administration
• Support for VARBINARY(MAX) field type in ADS

  Hello I have a user case that requires migrating Salesforce objects that contain attachments such a…

  Answered 76 views 2 comments 0 points Most recent by Henry Simms November 2024Support
• Data Studio Salesforce Connection

  Connecting Data Studio directly to your data sources and CRM systems, like Salesforce, has never be…

  126 views 2 comments 6 points Most recent by JRowe November 2024Feature demos
• Fuzzy Matching Logic

  Hi, I have a requirement to match records from two separate systems on the basis of FirstName, Last…

  Answered 40 views 2 comments 0 points Most recent by Danny Roden November 2024General
• Automations and notifications.

  if I want to trigger automation if any workflow failed in that space. is that true for that case as…

  Answered 38 views 6 comments 0 points Most recent by HussainSyed November 2024Administration
• swagger UI for find-duplicates- error. after recent upgrade.

  Hi, We are seeing this error after the latest upgrade. Upgrade done on our dev is as under.Upgrad…

  25 views 3 comments 0 points Most recent by Ian Hayden October 2024Administration
• Invoking PowerShell script from Experian workflow/Schedule

  Is there a way to invoke a PowerShell script from Experian Aperture Data studio using workflow or s…

  Answered 25 views 1 comment 0 points Most recent by Josh Boxer September 2024General
• Rows to Columns

  Hi, I have been testing out the Rows the Column function. However, it seems to be not pulling throu…

  Answered 44 views 4 comments 0 points Most recent by WilliamPerrin September 2024Support
• Flattening out / Pivoting / Transforming results

  Hi, I'm having an issue flattening out results. Essentially, I have multiple rows for the same cust…

  Answered 44 views 4 comments 0 points Most recent by Josh Boxer September 2024Support
• Compare Dates (Verbose) 📅📅

  Compare Dates (Verbose) [Category: Conversion] This function provides a summary of how 2x input dat…

  235 views 4 comments 1 point Most recent by christyjime September 2024Functions library
• 📣 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…

  56 views 2 comments 0 points Most recent by Josh Boxer September 2024General
• Error while invoking REST API from Experian Studio VM

  Background Experian data Studio version - 2.14.14 SSL setup done on the data studio url and private…

  Answered 72 views 2 comments 0 points Most recent by Henry Simms September 2024General
• ♻ Reusable workflow example – calculate word frequency

  Today I’d like to share with you a reusable workflow that I built a little while ago not only as a …

  147 views 1 comment 3 points Most recent by christyjime September 2024Reusable Workflows
• Experian Aperture Data Studio REST API error

  Hi, I am planning to automate dataset creation using Data studio REST API, however I am getting 401…

  Answered ✓ 73 views 3 comments 0 points Most recent by Josh Boxer September 2024General
• 👩‍💻 The HTTP Request (REST API) step

  This post is to raise awareness of an additional workflow step, that is increasingly being used to …

  176 views 1 comment 3 points Most recent by KatriM August 2024Feature demos
• Assign latest changed id to all linked records

  Hi, I have a scenario where input file is providing changed address ids in from-address and to_addr…

  74 views 5 comments 0 points Most recent by slngupta_1 July 2024Tips and tricks
• Error attempting to delete match store

  Hi, In my project, we are using Experian Aperture Data Studio(2.10.10) to connect to a Remote Find …

  Answered 109 views 9 comments 1 point Most recent by Shreya April 2024General
• Issues with Dev Environment Post-Upgrade

  I'm reaching out to address some critical issues we've been encountering with our Dev environment f…

  41 views 1 comment 0 points Most recent by Ian Hayden March 2024General
• Use a View in the Map to target step

  The Workflow step Map to target allows the schema (column order and column names) of a table of dat…

  49 views 0 comments 0 points Started by Mirjam Schuke March 2024 Feature demos
• Data Management User Group 6 March 2024: Recap and reflections

  A note from Sarah Williams reflecting on the Data Management User Group that was held on 6 March 20…

  259 views 2 comments 14 points Most recent by Chris Roy March 2024Event recaps
• Managing Data Quality issues using Issue lists

  Issue lists allows Users in the same Space (including read-only Consumer users) to capture problema…

  87 views 0 comments 2 points Started by Mirjam Schuke March 2024 Feature demos
• Compare two data sources

  The Compare step allows you to detect and highlight differences between two data sources, e.g. year…

  152 views 0 comments 4 points Started by Mirjam Schuke March 2024 Feature demos
• 📋 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 1.2K views 8 comments 7 points Most recent by Danny Roden January 2024Functions library
• Business Validation and Enrichment

  Aperture is a powerful tool when validating business information you already have. We can leverage …

  81 views 1 comment 4 points Most recent by Danny Roden January 2024Tips and tricks
• UK Postcode formatter 🏡

  Summary This package contains a single function but may be updated in the future to include others.…

  133 views 4 comments 0 points Most recent by Lucy January 2024Functions library
• 🔎 Data profiling showcase

  Ever since Aperture Data Studio’s pre-curser, Pandora, one of our most used features and most loved…

  135 views 1 comment 0 points Most recent by Jaden December 2023Feature demos
• Aperture Data Studio 2.12.8, Find Duplicates 3.9.1

  We upgraded today our prod servers, and now we have the same situation, settings in find duplicates…

  37 views 1 comment 1 point Most recent by Ian Hayden December 2023General
• 🦸‍♂️ Data Management User Group event summary

  Last week we welcomed over 40 customers to our latest Data Quality User Group. Held in our London o…

  68 views 2 comments 1 point Most recent by Seamus Kyle December 2023Event recaps
• Use of If-Then-Else logic in Aperture Data Studio

  Imagine you are asked to use Aperture Data Studio to generate a new field for your sales data. You…

  162 views 1 comment 7 points Most recent by Tanj Jagpal December 2023Tips and tricks
• 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…

  151 views 7 comments 2 points Most recent by Danny Roden November 2023Tips and tricks
• Upgrade Issue, Aperture data studio , Find Duplicates latest versions

  Hi Ian, Looks like after the recent upgrade we have an issue that experianmatch path got changed t…

  62 views 4 comments 0 points Most recent by HussainSyed November 2023General
• Low Disk Space issue.

  Hi, We have the disk space issue once more for our data drive. We changed the index expiry setting…

  36 views 3 comments 0 points Most recent by HussainSyed November 2023Administration
• Standardise Country 🌎

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

  377 views 8 comments 0 points Most recent by Henry Simms November 2023Functions library
• Workflow is not in an executable state but no errors exist

  Hi DQ Community, I have a workflow that I can't run or publish because I get error messages telling…

  Answered ✓ 72 views 7 comments 0 points Most recent by Ian Hayden September 2023General
• Autonomous REST connection SQL query

  How can I get a simple SQL running when everything is set up . the Autonomous REST connection is su…

  257 views 18 comments 0 points Most recent by Henry Simms August 2023General
• Handling data from Experian Aperture Data Studio jobs

  We are getting error in the execution of Experian scheduled jobs as "There is not enough spac…

  Answered ✓ 38 views 2 comments 0 points Most recent by Josh Boxer August 2023General
• 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…

  Answered ✓ 55 views 5 comments 0 points Most recent by JRowe July 2023General
• Want to pass certain input from API to the workflow

  i am trying to call an API from an external website my agenda is to pass some IDs that will be take…

  Answered 24 views 1 comment 0 points Most recent by Josh Boxer July 2023General
• Copy of FiServ Files uploaded into DA & use of the Metro2 Parser

  Does anyone use Data Arc with a copy of a FiServ Metro2 File? We are setting this up as net new an…

  Answered 90 views 6 comments 0 points Most recent by Josh Boxer July 2023General
• Stored Procedure invoked from PostSQL of Export step is not processing all records

  hi, In my workflow, I am connecting to SQL server 2012 using Custom JDBC jar (Microsoft JDBC Jar 12…

  Answered 54 views 4 comments 0 points Most recent by Shreya July 2023General
• Date formats...

  Earlier today I received the below email from a customer which I wanted to post on here in case the…

  98 views 1 comment 0 points Most recent by Danny Roden July 2023General
• Error while connecting to Embedded Duplicate Store

  Hi, I am getting error as below when I am trying to connect to the Embedded Duplicate store in my D…

  Answered ✓ 81 views 2 comments 0 points Most recent by Shreya May 2023General