-
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’…
-
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?
-
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.…
-
Aperture Data Studio Hosted and Managed Service Maintenance Schedule
For our customers on the Aperture Data Studio Hosted and Managed Service: The maintenance schedule is now available on the Community site at this section. There is also an option to subscribe to maintenance status updates at the Experian Data Quality status page.
-
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…
-
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…
-
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
-
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…
-
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
-
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…
-
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…
-
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…