Aperture Data Studio
Discussion List
-
Validate Datetime Datatypei want to validate that the column datatype is "Datetime" Datatype. i found only "Is…
-
How to save profiling result as view for multiple table(50+ tables)I have many tables, i need to run profiling on each of the tables and need to save the results as v…
-
STS account - Reactivationhi @Ian Hayden , Sent you an email regarding reactivation of STS acc. we have tried to contact ser…
-
Guidance Needed: Transitioning Data Sources from HD Insights to DatabricksHi Team, We are anticipating changes in our datastore architecture, which will significantly impact…
-
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…
-
UK Postcode checkHi, I have a requirement where I receive a csv file with postcode(no other address fields is provi…
-
ssl cert update process.has the process changed to update ssl cert on newer version? previously i used to do this, and hi…
-
5Group Step > Being able to select and right click view multiple rows in groupsWhat problem are you facing? When the Group step is used, we can only view rows in group on one va…
-
Kill Dataset refresh job via APIhi, I am performing bulk data profiling on datasets using API automation where my steps are as belo…
-
Delimited csv file creation using Export stepHi, We are using Experian Aperture Data Studio version 2.14.14.40 and have changed the settings to …
-
PerformanceWe have just stood up a new server that is the same spec as our old server but has a slightly new v…
-
Adding Microsoft SQL Server to an ADS serverHas anybody got any experience in having Microsoft SQL Server and data tools installed on the same …
-
Support for VARBINARY(MAX) field type in ADSHello I have a user case that requires migrating Salesforce objects that contain attachments such a…
-
Data Studio Salesforce ConnectionConnecting Data Studio directly to your data sources and CRM systems, like Salesforce, has never be…
-
Fuzzy Matching LogicHi, I have a requirement to match records from two separate systems on the basis of FirstName, Last…
-
Automations and notifications.if I want to trigger automation if any workflow failed in that space. is that true for that case as…
-
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…
-
Invoking PowerShell script from Experian workflow/ScheduleIs there a way to invoke a PowerShell script from Experian Aperture Data studio using workflow or s…
-
Rows to ColumnsHi, I have been testing out the Rows the Column function. However, it seems to be not pulling throu…
-
Flattening out / Pivoting / Transforming resultsHi, I'm having an issue flattening out results. Essentially, I have multiple rows for the same cust…
-
Compare Dates (Verbose) 📅📅Compare Dates (Verbose) [Category: Conversion] This function provides a summary of how 2x input dat…
-
📣 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…
-
Error while invoking REST API from Experian Studio VMBackground Experian data Studio version - 2.14.14 SSL setup done on the data studio url and private…
-
♻ 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 …
-
Experian Aperture Data Studio REST API errorHi, I am planning to automate dataset creation using Data studio REST API, however I am getting 401…
-
👩💻 The HTTP Request (REST API) stepThis post is to raise awareness of an additional workflow step, that is increasingly being used to …
-
Assign latest changed id to all linked recordsHi, I have a scenario where input file is providing changed address ids in from-address and to_addr…
-
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 …
-
Issues with Dev Environment Post-UpgradeI'm reaching out to address some critical issues we've been encountering with our Dev environment f…
-
Use a View in the Map to target stepThe Workflow step Map to target allows the schema (column order and column names) of a table of dat…
-
Data Management User Group 6 March 2024: Recap and reflectionsA note from Sarah Williams reflecting on the Data Management User Group that was held on 6 March 20…
-
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 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…
-
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…
-
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…