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 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.…
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.
Hi, started looking at 'Validate Address' step and cannot find a data dictionary for the returned fields. For example, AddressAction I see 0 & 3 and Street Non-trivially Corrected I see blanks, 0, 1. Any pointers would be great, thanks
For example I have a column where I have Value like this If I use function contains then I am getting this true for all of the above scenario, but I want only row 1 should be true and rest should be false when the entire string is not matching. Can this be done?
Hi, is it possible to turn a list stored in a column into rows? For example: ID COL 1 AA,BB,CC 2 XX,YY,ZZ Becomes 1 AA 1 BB 1 CC 2 XX 2 YY 2 ZZ Thanks
Hi team, Suddenly the aperture data studio application is connecting. We tried to restart the services and the services are still stopping .we are unable to restart the services. Can you please help us to resolve this issue ASAP .
Hi there, How do add columns on a dropzone file? The columns have been added in the source file but it's not reflecting on the dropzone file in aperture. How do I fix this? I have tried adding a new external system but it doesn't work. Many thanks, Mariana
Hi, I have a requirement to match records from two separate systems on the basis of FirstName, LastName and DOB from System1 and FisrtName, MiddleName, LastName and DOB from System2 to return the match Id from System2 to System1. Below are the challenges The names are not consistent in both systems . For eg in system1 for…
I am trying to create a development environment to test some changes but when I try to import anything to it, gives me this network error message. Any ideas on what the problem is? I am connected with the VPN, already checked that! TIA, Mariana
A user asked this question: We have hundreds of datasets we need to refresh before a migration, what is the best practice in ADS to make sure they have all been updated, without adding a source in a workflow for every dataset can you iterate through the desired datasets and look at the metadata to determine when it was…
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…
Good afternoon, We are currently using the "Validate Addresses" step to check UPRNs. However, we have observed a significant number of addresses—where we already know the UPRN—that are returning empty during validation. Could you please confirm how frequently the Royal Mail address database is refreshed? Thank you for your…
Join us for a day of networking, in person to hear from industry experts about what’s happening in the world of Data, AI along with real-life case studies on successful data transformation initiatives. We are offering this session in person only so that you have the opportunity to be part of a community that will drive…