Learn, collaborate and solve problems with like-minded data quality enthusiasts.
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.
Welcome! Find out how to get the most from The Community.
This is the place to ask a question or to start a discussion.
Get help and keep learning and expanding your knowledge.
Find out about new features, download the latest releases, and read case studies.
Find out what's coming up, suggest ideas, and take part in exciting research with us.
Hi all, We’re excited to invite you to our upcoming in-person Data Governance Masterclass on Thursday 9th October, featuring Nicola Askham – The Data Governance Coach. This event is designed for data leaders like you who are looking to enhance governance strategies, hear real-world success stories, and connect with peers…
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?
Recently developed a function based on the Haversine Formula to generate the distance between two coordinates (in meters). It's useful for comparing distance approximations between different address points. Simply copy the below text into the function script editor: param Point 1: Latitude; param Point 2: Latitude; param…
Hi, I have a validation step that performs a 'Contains Match' on a lookup table (I am checking FK integrity). The workflow is set to 'Refresh Sources' however this does not apply to the lookup table. (I noticed due to failed rows). What is the recommended best practice here? Thanks
i have some date columns in my table (like below example). Just done profiling on those columns it recognizes their datatype as alphanumeric instead of date. after profiling i just right click and seen the values, there it shows as Date datatype all rows have date only in MM/DD/YY format because of this i am getting wrong…
I am not sure how to apply distinct count as aggregation while do group by ? There is check box "distinct", even though i enable that still does not give distinct count. Can someone help me to apply distinct count as aggregation in group by
Today I’d like to share with you a reusable workflow that I built a little while ago not only as a downloadable .dmx file (see below) for you to explore/use as you wish, but also as a means of demonstrating one of the key themes of Data Studio…reusability. If you find that there are duplicate tasks being executed on your…
Recently we upgraded to experian 3.1, and i would like to try Workflow Scripting (preview). But i unable to find those feature. Can anyone please help me with this?
What problem are you facing? As a Find duplicates user I want to be able to manually evaluate and change clusters of records where I think the rules have matched records incorrectly e.g. I've got a husband and wife in my data, both called M. Smith and they share the same postal address, email address and loyalty card…
What problem are you facing? The Email and Email_Local elements in Find Duplicates Standardization currently retain all characters by default, including dots (.) and plus-aliases (+alias) in the local part of email addresses. This means that emails like johnsmith@email .com, john.smith@email .com, and john+alias@email .com…
Every now and then a scenario crops up where it'd handy to know how often a given word occurs within a given dataset. For example you're profiling a reasonably standardised list of values (e.g. job titles) and you want to identify unusually common terms (like 'manager' 'executive' etc) or infrequent ones (like 'test123').…
Hi All, I’d like to ask whether Aperture is capable of directly connecting to OpenText Content Server, without requiring any middleware or intermediate systems (such as Talend or external scripts). Is there a native connector or export integration available for pushing data directly from Aperture into Content Server?…