Learn, collaborate and solve problems with like-minded data quality enthusiasts.
The Data Quality Community is a great place to collaborate, seek answers, and learn Aperture Data Studio. Register for free to join in with discussions.
Welcome! Find out how to get the most from The Community.
This is the place to ask a question or to start a discussion.
Get help and keep learning and expanding your knowledge.
Find out about new features, download the latest releases, and read case studies.
Find out what's coming up, suggest ideas, and take part in our beta program.
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…
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…
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!
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…
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
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…
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…
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
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
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…
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…
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…