Experian Data Quality Community

Learn, collaborate and solve problems with like-minded data quality enthusiasts.

Spaces for sharing
We're experiencing a problem when trying to share Views. Specifically, when selecting Spaces for sharing, we receive the following error message: Has anyone else come across this? Any insights on what might be causing it or how to resolve it?
PRODUCT ADVISOR UPDATES – MAKE SURE YOUR OPINION IS HEARD 📢
Hi all, I hope you have had a great start to the week. Thank you to everyone who has signed up as a Product Advisor; your contribution is invaluable to us. The community of Advisors has grown massively from 20 to over 120 members in just over a year, but we are always striving to further diversify the opinions and voices…
Sneak peak of new data quality offering: Let us know what you think
Hi everyone, In this post I'd like to provide you all with a sneak peak of a new real-time data quality enforcement offering that we're currently exploring, that we'd love to get your feedback on (complementing our existing contact data validation products). The idea centres around exposing Data Studio functionality (e.g.…
Customizing your Dashboard with the Custom content widget
Data Studio Dashboards can be configured by adding, ordering and resizing different widgets including Views and Charts. One of these widgets is the Custom content widget: Firstly drag the Custom content widget onto your Dashboard. Next add some text that your colleagues will find useful: Add style 🕶 To make this…
Connecting to an Amazon RDS MySQL Database
A user recently asked about connecting Data Studio to their AWS RDS MySQL Database. The first thing to note is that MySQL on RDS uses the MySQL community edition, which is not supported by Data Studio's native JDBC driver. When attempting to connect, you'll receive this error: "Connections to MySQL Community Server are not…
🔔 Follow what you're interested in
When you navigate into any of our categories you will see a Follow button in the sidebar. This will allow you to subscribe to getting email notifications and notifications in the community about that topic. So for example if you want to be notified of new releases, navigate to the release and downloads section and click…
How to modify in aperture the header for Powercurve Collections interfaces
I am working on the input interfaces that PCC manages, which has the following nomenclature Row-count | ProcessingDate Here is an example: 20250603|5762202 1416|81178235||Vendor|| 6700|81380685||Sold-From Party|| but I can't get the columns to join correctly. as a result I have this 20250603|5762202…
Guidance Needed: Transitioning Data Sources from HD Insights to Databricks
Hi Team, We are anticipating changes in our datastore architecture, which will significantly impact datasets and views currently sourced from HD Insights. These sources will need to be repointed to Databricks as part of the transition. Could you please advise on the possible solutions or best practices for handling this…
Fire event - if input has no rows
Hi All, I would like to fire an event (run a specific workflow) if NO rows in the input - but there is only an option to fire events if input has rows: Basically the goal is to only send correct data to an external system (Snowflake) if there are no errors (at all) in a dataset. Is there a way to set this? Many thanks!…
What is the cause of an error message that says "4058: Unable to rollback" and how can it be fixed?
This error occurs on the Export workflow step.
Column header in the second row
Hi All, is there a way to use the second row (instead of the first) as the column names when uploading dataset? Or is there a workaround? There is a dataset that we would like to drop into the DropZone but the header is always in the second row… Many thanks! Vera
Is there an easy way to do this partitioning?
Hi, I have seen previous posts on partitioning, and use that technique regularly. However, my need this time is slightly different. I have groupings of duplicates, but I would like to count incrementally when I come across a new identifier. I actually have this working now, but it took some Aperture kung-fu, so wondering…
Auto discovery of keys (foreign, primary)
Logging this idea on behalf of @AlanB (feel free to add further commentary) What problem are you facing? We are starting a migration project from a largely undocumented system and need to identify how the various tables relate to one another (e.g. what are the foreign / primary keys, potential joins as well as conducting…
fill down or propagate values to empty cells
Good morning, what's the best way to fill down or propagate values for fields like 'Year' and 'Submission Month Name' so that all rows in a dataset display these values consistently? Many thanks in advance
api key expiry notification
hi, can someone tell me simple steps to create alert on my api key, so that before it expires, i get an alert, email alert or something else? Br, hs
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 know via email, before api keys expire. Br, HS i want to know before hand, https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/monitor-data-and-troubleshoot/
Tagging as sensitive information
Hi All, As I'm reviewing the space settings, I noticed there is a section called "Potentially Sensitive Information." Could you please let me know how to tag specific columns in a dataset or view as sensitive data? In some cases, we need to create restricted views, so it would be helpful to have a clear way to identify…
Export views, datasets, schedules etc.
Dear All! Is there an easier way to extract all the views, datasets, schedules etc. information from a space or across different spaces? I mean what we have in this GRID for examples for the views: I need to create different reports and it would be time consuming to select and copy-paste. Many thanks! Kind regards, Vera
Our Data Management User Group is on 20 May 2025
Once again we would love you to join us for our next Data Management User Group taking place on 20 May 2025 between 10:00am – 4:00pm at our offices in Cardinal Place, Victoria, London. This will be a special User Group event as we have an opportunity to share a real milestone in our product innovation. Our ‘new generation’…
Sorting is better to do before Join?
Does sorting of the participating ids in the joining condition helps in better performance? i thought if I use a sort step before Join that will improve my performance but it is actually taking 15+seconds extra when I am using sort step before join, is there any other way to improve the performance time or it is not…
space issue in data folder.
we have space issue on our indexes, I believe in last 2 days, that has grown more than 600GB, how could it be, can you help us investigate? br, HS
character encoding mismatches
Hi, I'm having an issue when downloading a dataset in CSV format, some of the characters are been introduced on the download such as â€™s instead of " ' ". Is there a setting or function to prevent this issue? Best regards, Marco
Highlight steps connection in Read Mode
What problem are you facing? Users without edit permission can't trace the flow between workflow steps in large workflows. It would be useful if the lines could be highlighted when clicked on (like in edit mode). What impact does this problem have on you/your business? It impacts productivity, takes a long time to trace…
Configuration of Line Endings in Export Step
What problem are you facing? The option to select what type of Line ending that should be applied to an export What impact does this problem have on you/your business? Different clients have requests on the specific file format they want depending on how they load these files. There are some that request their files with…
Repository backup - Linux
Hi there, I found on the documentation that is possible to have a repository back up setup on the windows installation but we are using a linux deployment, is it possible to do this if we are not using windows? TIA
Exporting - Extension Missing?
Hi, just upgraded to version 2.14.12.195 and noticed something in the 'Export' step. If I export to CSV, Excel etc. and my file name is split with a full stop, the extension is suppressed. For example file name "FILEOUTPUT" gives me" FILEOUTPUT.XLSX" but "FILE.OUTPUT" does not add the .XLSX extension. I noticed because…
On Schedules List Screen - Include whether Refresh Sources
What problem are you facing? On the schedules list screen, I have to go into each individual item to confirm if 'Refresh Sources' and what type of schedule has been configured (Refresh dataset or Run workflow). What impact does this problem have on you/your business? Ease of use impacted. Having 'Refresh Sources' and 'Task…
Export issue - values not appearing
Hi All, I’m wondering if this might be a known issue: I have a workflow using a re-usable workflow that includes a lookup to check whether certain records exist—so the result should be either true or false. When I run the workflow manually, the true/false values appear correctly in the exported file. However, when the…
🎉 Aperture Data Studio Version 3.0 - Almost here
Aperture Data Studio v3.0 is almost here and we're very excited to share this update with you. Full release notes will be added once the download is available. First to note: v3.0 is like any other quarterly release but you will have to have moved to cloud licensing. If you upgrade without a cloud license token applied (or…
Need to connect databricks
Hi Team, We need to connect data bricks workspace(pre-prod and prod) from our aperture pre-production server. Could you please check and confirm that whether we can be able to connect data bricks from Aperture data studio. Also please let me know if we need to be installed any JDBC driver. Regards Uma
UK Postcode check
Hi, I have a requirement where I receive a csv file with postcode(no other address fields is provided), and I need to do the below 1. Mention if the postcode is Valid and compliant as per Address GBR data 2. Standardize raw postcode value to UK postcode format 3. Specify the reason for UK postcode being…
Session API is now set to get first 100K
What problem are you facing? It looks like the Sessions and Events endpoints have an internally configured maximum number of records to return, which is set to 100k. This would be in place to prevent the API response from getting too large, but paging of the response would seem to be a better solution. What impact does…
Unable to access Session API
I am not able to access the Session API from Swagger, it showing me 401 as response code. We have Aperture as external system we are not able to fetch the records from Session but able to get the other metadata information. I checked in Progress data direct response code for Session are 401 there as well and even in…
Aperture link to Googlesheet thru BigQuery
I am in Aperture Version 2.8.8.27 I am trying to get connected to Googlesheet thru BigQuery. BigQuery is set up with link to Googlesheet and connection to BigQuery from Aperture seems to work ok. External system Connection is OK, using Service Account with .jason Private Key File. But when I try to add dataset in aperture…
Manually reviewing clusters of duplicate records (Stewardship)
What problem are you facing? As a Find duplicates user I want to be able to manually evaluate and change clusters of records where I think the rules have matched records incorrectly e.g. I've got a husband and wife in my data, both called M. Smith and they share the same postal address, email address and loyalty card…
UX Improvements / Suggestions - Jobs Page
We had a recent scenario where 1k jobs were sent to the queue, which did flag up a couple of UI/UX suggestions for the 'Jobs' page: Is it possible to multi-select to cancel jobs? We could only see the option to delete one job at a time in the queue? I.e. would be good to be able to select all jobs, multiple jobs or single…
ssl cert update process.
has the process changed to update ssl cert on newer version? previously i used to do this, and hit save, now i see this, and does the section for public certificate needs to be empty? you guidance will be really appreciated, as our cert is expiring in 1 month or so on our dev server. Br, HS
Allow worksheet naming at the Export step
What problem are you facing? When exporting data to Excel, I like to have each worksheet named according to the function or type of data being presented. To do this, the prior step must be named and that gets passed to the export step. However, if the workflow is changed and new steps are added prior to the export, the…
Pass step data to Fire event?
Hi, I thought I had this set up correctly, but testing reveals otherwise. I have a reusable workflow that is set up to send data passed to it to an external destination (as an Excel file). However, I only want to run this when the data being fed has rows. The reusable workflow is fine when used in a workflow - it uses the…
Aperture service down
Hi Team, The aperture pre-production server database service has been stopped abruptly. 2025-03-04 22:00:48,784 INFO c.e.d.j.d.JobDatastoreImpl [jobControllerSystem-pekko.actor.default-dispatcher-2129] The repository service shutdown has already been invoked, nothing to log out. 2025-03-04 22:00:48,802 INFO…
ℹ️ Importing your Datasets into Excel or Tableau using OData
You can easily get your data from Data Studio into Excel or Tableau using OData. OData (odata.org) is “an open protocol that allows the consumption of data via a simple and standard RESTful API”. If you choose to turn on OData in Data Studio (v2.2.3), you will be able to link your datasets (including snapshots) to any BI…
Rulesets and Rule Name
Hi, I want to explore using Rulesets, but the naming of rules is stumping me. I want my rule name to be the mapped column I am using, followed by a short description. Column=V_ID and description=not null. The rule name created though is "V_ID-Input - not null" - it is pulling in the input column from the ruleset definition…
What's the syntax for the Dataset "file pattern" text when loading from an SFTP dropzone?
I'm setting up a Dataset that automatically refreshes with data from files dropped into an External System dropzone (SFTP in this case). I only want to load specific files, determined by the file name. To do this, I was going to use the "Starts with file pattern" config option, but I couldn't find any information about the…
Aperture using workflow to export via JDBC - Issue
Hi, Please can you help/advise? I am trying to export dataset containing 79k records (83 columns) to HDI table, which is failing. However, if we limit the record to 4 or 100 the export to HDI works perfectly fine. Also, please find below error: Unexpected errors have occurred during Workflow execution: 9003: An unexpected…
A way to avoid writing zero-row batches to Datasets
What problem are you facing? I have a workflow that runs regularly, and includes a filter step that only retains "error condition" records. These records are then written into a multi-batch snapshot using Take Snapshot The problem is that most of the time, there are no error conditions, meaning there are no rows to write…
Understanding Cloud Licensing Security Setup
If your account manager or consultant has recommended upgrading your Aperture Data Studio deployment to a cloud license, it’s because Aperture Data Studio v3.0 will only be available through cloud licensing. Cloud licensing brings many benefits (for more details, please refer to this write-up), but might require some…
Trend NOT showing with Date as X axis
I am getting trend when using a different column in X axis than Date But when I am using Date the trend is not coming its BLANK. I have date as the Batchtime metadata, and I am trying to use the trend on below data I have done trend many time earlier where I had seen trend was coming good even if I have the date in x axis…
Set Space & Dashboard as a default?
Is it possible or has it been discussed about having the option to specify a Space and Dashboard as a default at log-in?
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 value. What impact does this problem have on you/your business? Feedback received of this not being user friendly and having to exit the screen to be able to get to the multiple filtered values. Do you have any existing…
Combine Filter/Split step
Hi, I'm raising this on here as it's come up a few times with various users and I want to see what others' think of the idea to essentially combine the filter and split steps (which perform the same action, with the only difference being the split step allows users to view unfiltered results): vs I myself have found on…
Sticky Notes attached to Workflow step
Just a thought… but it would be really nice if Sticky notes could be pinned to workflow steps (I always provide decisions or descriptions of steps as part of knowledge transfer). That way if I move my workflow step the Sticky note comment moves with it (or worse, someone hits the auto-arrange button and now my Sticky notes…
📊 New chart types
With an increasing number of users now spending more and more time building (and then interacting with) charts and dashboards, there are a couple of additional requests I'm hearing cropping up relating to this so I'm posting them on here for discussion and to get the wider Community's thoughts. They are: Adding some new…
Prevent object tags from requiring a workflow to be re-published
What problem are you facing? I have applied the new Object Tags to various workflows. In each case the workflow status changed from Published to Draft when the Object Tag was saved. The tags can be bulk added but the workflows must then all be individually re-published and a comment added. What impact does this problem…
Import from Sharepoint list
Hi, Is it possible to connect Aperture to a SharePoint list without having the export to excel and then re-import? If it is please could someone walk me through how? Thanks!
Error message
When trying to access details of Monthly Validation Results Summary Interactive_CAIS2007, an error message appears: 6029 - An unexpected error occurred. Please try again or contact whoever manages Data Studio in your organization. Can someone please advise, is it something I'm doing wrong? Thank you
Interactivity not Working
Hi, I have the data interactivity available till this point in my workflow where I am doing multiple grouping and then brought them in one place by union Here is the Workflow screen shot, where till 1 (marked in the SS) I am interactivity . Output of transform step shown above. And now this I am trying to take in…
Enabling hard delete using the Salesforce connector
When deleting data from a Salesforce object you can tell the API to hard delete the data so that it does not go in to the recycle bin and therefore can't be recovered. It's also possible to do this with DELETEs in the Export step using the native Salesforce JDBC driver. Here are the steps: In your Salesforce External…
Multiple column return in Lookup
Is there a way to return multiple columns from the lookup table in return I have DS1 and looking up DS 2 and want to return 3 columns from DS2. My final output will be all col from DS1 and 3 cols from DS2. Trying with Lookup type "All Value" but in this option just getting 1 column in return
Lookup or Joiner using Contains in the Match
Is it possible to do below check I have this in one channel Want to check and populate 'Issue Pending' column value from other channel where it has comma separated values
Updating Issue List Fails
Hi, I am trying to update an Issue List (approx 50,000 rows that need updating). I try and run a workflow to do this but it fails with the message below. I go to rerun the workflow and it runs for a while but then ends again. Each rerun only lasts about half the time as the previous one. I don't have access to the logs for…
Case statements in Aperture Data Studio V2
Hi everyone, I’m looking to convert a SQL query in Aperture, which contains multiple CASE statements for a single column in the dataset. I’m looking for the best practices to achieve this efficiently and clearly. The column I’m working with contains various conditions that need to be evaluated. Could anyone share their…
Kill Dataset refresh job via API
hi, I am performing bulk data profiling on datasets using API automation where my steps are as below list all datasets to be data profiled in a csv file process csv for each row trigger dataset refresh and capture job id wait for job to get completed or for max 30 mins. if time elapsed is more than 30 mins then skip next…
To be able to use groups and group permissions when using SAML and LDAP
What problem are you facing? Administrators are currently having to add individual users. This is a pain when a customer has more than 10 users to add. What impact does this problem have on you/your business? Not user friendly and time consuming to add users. Do you have any existing workarounds? If so, please describe…
Unable to connect Amazon redshift database
We are trying to connect Amazon redshift database from aperture, and we are getting the below error while trying to connect. Failure com.experian.aperturedatastudio.redshift.jdbc.base.fv: [ApertureDataStudio][Redshift JDBC Driver]Error establishing socket to host and port:…
Include Metadata in the Export step
What problem are you facing? I would like to include metadata in the export step (specifically in the JDBC option) that includes metadata for the target system and table (e.g. tablename, DBMS system, credentials used etc.) as this would help users / DBAs to debug/resolve any issues or be included in a point-in-time audit…
Updating Data via Aperture vs SQL
Hi, Was hoping fellow-customers or Experian staff would be able to give their experiences with this one. Wanting to update data in the DB directly using Aperture (thru the Export step - JDBC), but the DBA wants updates done via SQL scripting (is hesitant to use Aperture). I am pushing for Aperture as it is a controlled,…
Aperture REST API calls as Datasets within Aperture
Data is available from Aperture via the REST API that is not available in Aperture. Full details of Spaces, User Groups, Users, Jobs, Datasets etc. We would like to use Aperture to manage Aperture. For example: An automated workflow which checks for long running jobs and notifies us of issues; a regular review of user…
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 accept csv delimiter to pipe (|) But there is a requirement to delimit csv files based on runtime configurations. Is there a way to define the delimiter in the export step while writing datasets as csv likely from a parameter?
Adding gzip Compression Method
What problem are you facing? gzip(.gz) compression method option not available when adding of compressed datasets and in the export step for compress or compress and encrypt. What impact does this problem have on you/your business? Most internal and clients files are compressed using .gz. This is has been the case for…
Issue list as a source for charts & indexes?
It would be so helpful if Issue lists could be used as a data source for charts and indexes. For example, I have a nice donut chart of my issues (includes custom status) that I share with a customer in a dashboard. Currently, I have to send the issue list data to a dataset and then let the chart use that dataset for the…
Exporting to External System using JDBC
Waiting to get an external system set up to allow updates via JDBC - in the meantime, if I select mode = UPDATE in the export step, does a full SQL statement get generated (to allow our DBAs to verify and QA the process). Thanks
Issue list best practices
Hi, I am starting a data migration/cleansing project and as each entity is analyzed and validated with data quality rules, any failing rows are sent to an issue list. That issue list is then shared with business leads to determine best approaches to fixing the data. There will be approx. 70 entities that we will working…
connect to Snowflake external system with OAuth 2.0 authentication method
Hello, How can we connect to Snowflake external system with OAuth 2.0 authentication method? Thank you
Suggest Validation rules - Validate step
Aperture Data Studio has a Validate workflow step that allows you to define rules of how data in specific columns should be populated. This information can then be used to be alerted to any data quality problems or to track data quality improvements over time. These rules can be simple: should not be null should be a…
Performance
We have just stood up a new server that is the same spec as our old server but has a slightly new version of ADS but workflows are taking 5 to 10 times longer to run, does anyone have experience in tuning ADS?
Best practices designing complex Workflows
A Workflow is a sequence of steps that defines a process to transform and manipulate your data. When a single Workflow tries to tackle too many actions it can become difficult to read, understand and manage: If you are designing a Workflow alone this might be fine, but if you are collaborating or planning to have others…
UX Improvement - Output label case sensitive
What problem are you facing? The Workflow step output names/labels are being all converted to lower case when the reusable workflow is added inside another workflow. What impact does this problem have on you/your business? It makes it more difficult to distinguish between outputs, especially when there are several, which…
Native Function: Is Web URL
Hi, I am using the above function and the result for checking this site "www.californianotary.academy" comes back as bad, even though it can be accessed in a browser. Does that function expect something like ".com" rather than ".academy"?
Update Issues once Resolved?
Hi, is it possible to update an issue once it has moved to 'Resolved'? For example, a set of data gets manually updated, and after resolution we want to reflect that via the 'External ID' (e.g. a ticket number). Thanks
Adding an Owner to my business rules
Submitted on behalf of a customer. We have created many different validation rules to monitor the quality of different datasets over time. It would be useful to denote who is the owner of a specific rule in case changes need to be made in future.
Automated date in output
I wonder if there is any way of setting up in an automation the Take Snapshot step with the date information on it. Like for example: ADSExtrac_20241113.csv
Suggested approaches for manipulating JSON values
My data includes a column containing JSON values - I've made a dummy example below: Example JSON value: { "magenta": "#f0f", "yellow": "#ff0", "black": "#000", "usageList": [ "giraffe", "lion", "axolotl" ], "properties": { "cost": 99, "difficulty": { "part_a": "hard", "part_b": "easy" } } } I have a couple of requirements:…
Is it Possible Integration with with NETCONF Protocol ?
Can Aperture Data Studio integrate with device configuration system with NETCONF Protocol
Sorting an Issue list results in fewer rows
hi, So I have a workflow that I use an 'Issue list' as my source - the issue list has 29 rows. If I add a step to sort on the 'Failed Rows' column, my output for that is now 22 rows. No other filtering going on. Tried it on 2 different issues with the same result. However, if I remove the sort on the 'Failed Rows' column I…
Looping workflows
About the requirement Recently I’ve been asked a couple of times if it’s possible to cycle through a workflow for every value within a given column. This is mainly to drive 2x types of use case: Dynamic data export – effectively taking an input dataset and splitting it out into a separate file for each subset of data (as…
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 server as ADS is installed on which uses SQL Lite, we were wondering if they would interfere with each other?
Is it possible to configure which events are included in the audit report?
There would be a need to get some more events included in the audit report, is that possible to be configured by the administrator?
Support for VARBINARY(MAX) field type in ADS
Hello I have a user case that requires migrating Salesforce objects that contain attachments such as HTML Body, PDF's, Word, Excel and jpg's attachments to another instance of Salesforce. These are normally stored as a VARBINARY(MAX) in a MS SQL database and I think would be a Blob in SQL Lite. Given these data types are…
Best approach for this set-up?
Hi, Any recommendations for this configuration? Lets say I have a space called 'PROD-DQR' that is used to access production data with a read-only credential to the source DB. It validates data, sends to issues etc. Only DBAs are allowed to perform updates in production, so was thinking: New spaced called 'PROD-UPDATE' that…
Rule Question (DataArc360)
Hello, Can someone help me understand a rule and why certain criteria is listed? Rule name- The DOFD is more recent than normal on a derogatory account Why did they select those Account Statuses? For instance, Account Status 95 can be reported if an individual is not 120 late since the member is voluntarily surrendering…
How to resolve "No space left on device" errors
Hello, In the last few days we have been encountering the "An unexpected error has occurred during Workflow execution: 9003: An unexpected error has occurred during Workflow execution. No space left on device" error. We have gone through our installation and removed a lot of datasets that we no longer need which should…
Dynamic Reports in workflow - if x then do, if y then do something else
Hi all I'm new to Aperture and have just built a report in a workflow. It looks good and I am happy with the tables that I have pulled through. My report shows a summary of all of the checks and then I have an individual table showing the failing rows for each of the rules. Of course, sometimes, I have a rule that doesn't…
Data Studio Salesforce Connection
Connecting Data Studio directly to your data sources and CRM systems, like Salesforce, has never been easier. This video is to remind and inform users, just how easily two systems can work in harmony, without any complex development. We've created out of the box connectors, for a wide range of common platforms, to make…
Annotate Columns
Hi, is there a quick/easy way to mass update when performing 'Annotate columns'? I want to add tags not based on the data contents, but on security definitions. E.g. Some columns could be PUBLIC, some could be CONFIDENTIAL. Thanks
Experian Aperture Data Studio Report View
Hello. new to the tools trying to figure things out. Making progress, I've created several workflows successfully, and created datasets using snapshot, and used those datasets in other workflows and views. My question concerns Report View In Workflows. I've found very little documentation on this. I added a Report to the…
Data Studio certified to run on Azure Stack HCL or Nutanix?
Is Experian Data Studio application certified to run on Azure Stack HCI (Azure's version of VMware) and/or Nutanix?
Unable to connect Find dupliactes on new server
Hi team, We have recently installed the aperture Data studio application recently on our new pre-production server and we are unable to connect find duplicate server due to the below error. Please help us to this issue 2024-11-04 00:05:32 205 WARN c.e.d.m.MatchServiceManager [MatchLicenseMonitor] Unable to connect to Find…
Do you have a need for Pivot/Unpivot steps?
As part of our product discovery activities, we would like to find out if any of our clients have a use case for pivoting or unpivoting data. If you do, we'd like to hear about it. Please leave us a message and we'll get in touch.
OAuth 2.0 authentication method with Snowflake
What problem are you facing? How can we connect to Snowflake external system with OAuth 2.0 authentication method? What impact does this problem have on you/your business? We cannot develop new functionalities. Do you have any existing workarounds? If so, please describe those. We can connect through a user ID / password…
UX improvement - connecting Workflow steps
Submitting on behalf of a user: What problem are you facing? Sometimes it can be a bit tricky connecting two workflow steps that have ended up far apart. What impact does this problem have on you/your business? It's a bit fiddly and slightly more time consuming. Do you have any existing workarounds? If so, please describe…
Fuzzy Matching Logic
Hi, I have a requirement to match records from two separate systems on the basis of FirstName, LastName and DOB from System1 and FisrtName, MiddleName, LastName and DOB from System2 to return the match Id from System2 to System1. Below are the challenges The names are not consistent in both systems . For eg in system1 for…
Export Data Object to external systems
Submitting on behalf of a client: What problem are you facing? Cannot export the new data objects to external systems, re-work of re-tagging is time consuming. What impact does this problem have on you/your business? Time consuming and need to match the object tags back to the relevant CDE's Do you have any existing…
Validate address data dictionary?
Hi, started looking at 'Validate Address' step and cannot find a data dictionary for the returned fields. For example, AddressAction I see 0 & 3 and Street Non-trivially Corrected I see blanks, 0, 1. Any pointers would be great, thanks
Automations and notifications.
if I want to trigger automation if any workflow failed in that space. is that true for that case as well. I was going through some documentation. Data Quality user documentation | Automations and notifications so here i would want the same for workflow failure. any workflow fails in that space, i want the event to trigger…
Any Function to check the one field in Present in the List of the fields?
For example I have a column where I have Value like this If I use function contains then I am getting this true for all of the above scenario, but I want only row 1 should be true and rest should be false when the entire string is not matching. Can this be done?
Turn a field storing a list into rows?
Hi, is it possible to turn a list stored in a column into rows? For example: ID COL 1 AA,BB,CC 2 XX,YY,ZZ Becomes 1 AA 1 BB 1 CC 2 XX 2 YY 2 ZZ Thanks