Get help and keep learning and expanding your knowledge.
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.
Get answers to our commonly asked questions.
Get in touch with technical support.
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?
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…
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…
Hi, I have been testing out the Rows the Column function. However, it seems to be not pulling through all the columns. In the DEV data set, I currently have 62 rows which I would like converted to columns. When using the Rows the column, it automatically only finds around 56. Wondering if anyone else has had a similar…
Hi, I'm having an issue flattening out results. Essentially, I have multiple rows for the same customer because they have different PII's. Is there any way of transforming / pivoting / flattening out the results to have one row for each customer? I have left a screenshot of mock-up data below to help people understand. I…
Hello, rookie here again. I'm trying to understand the output step but the only thing I can find in documentation is below. When do you use an Output step? Where is the output located? how do you use the output step in another workflow, view, etc.? When a re-usable Workflow is using the Output step, the step's data will be…
Hello, Our Automated Workflows have stopped working recently, and I've tracked the issue down to a broken Validate Addresses step in our cleansing workflow. As you can see "the Reference data:" option is greyed out and I cannot edit it. When I scroll over the exclamation icon the help text says "No reference data…
Hi, any reason why I would not have a JDBC option in the drop down for creating an external system?
We have been unable to trigger the License Expiring Event for 'License Days Remaining Less than 365' with a Notification to users. License Expiration is Aug 2, 2025. What needs to happen to trigger this event? We've had a dataset load, complete workflow and waited overnight. We were only able to generate an notification…
We have the following structure for some of our processes (there will also be a prod but the structure will be identical to below): The idea is that we have a space where all of the core datasets reside - from these, views are created. And these views are shared and used within any workflows we create in different spaces.…
