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…
Hi all, I hope you have had a great start to the week. Thank you to everyone who has signed up as a Product Advisor; your contribution is invaluable to us. The community of Advisors has grown massively from 20 to over 120 members in just over a year, but we are always striving to further diversify the opinions and voices…
Hi, The drop zones that I have set up for several subfolders for many files has stopped working, and even after a restart continues to not work. The log contains a lot (a lot!) of these messages: INFO c.e.d.d.ExternalDirectoryWatcher [ExternalDirectoryWatcher-e3649cf8-de9f-42e2-8eec-edee6e98c157 1369857878] Error fetching…
Hi everyone!, I have a table with 2 columns, the first one is the string I should check inside a field, the other column is the value I should replace if its a match. How can I achieve this without creating a function with lots of steps for each string I need to search and replace. ORIGINAL STRING NEW STRINGTEXTO NUEVO -|…
My data includes a column containing JSON values - I've made a dummy example below: Example JSON value: { "magenta": "#f0f", "yellow": "#ff0", "black": "#000", "usageList": [ "giraffe", "lion", "axolotl" ], "properties": { "cost": 99, "difficulty": { "part_a": "hard", "part_b": "easy" } } } I have a couple of requirements:…
how would i create a function that compares the date open to today's date
Hi there, I'm having this issue with the find duplicates step, can anyone help?
We've successfully configured an external system using Connection type: JDBC and DBMS: Apache Hive 6.0. I’m looking for guidance on how to set up a Schema-Flexible configuration. Specifically: Is it possible to use Schema-Flexible JDBC connections to support workflows that export data to multiple schemas? For example,…
What problem are you facing? Almost all the data loaded into my Data Studio instance has a mandated 90 day retention period. 90 days after load we want to delete any batches that remain. Most data is loaded into new Datasets (in new Spaces) because we are working typically on short-term, one-off projects. There are…
What problem are you facing? Improved Driver support for Teradata data warehouse platform. We currently have to use the JDBC driver supplied by Teradata, which is not native to ADS and it generally works, but we do encounter many issues like data type conversion issues. Would be nice to have an alternative Teradata ODBC…
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
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?…