The place for most Aperture Data Studio discussion
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.
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
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…
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 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…
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…
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…
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…
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…
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…
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…
