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.
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 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, 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.…
Can we import Excel or csv file into Aperture. TIA
We are using a JDBC Driver from cData to extract data from Zuora to a Dataset, some of the tables are 20 million rows. Aperture sends the query command to Zuora which produces a download file but it can take 10 minutes by which time Aperture has fallen asleep and the data is not imported. Does anyone know if there a…
