Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Introducing the new Functions Library - fast track your time to value with Data Studio!The Functions Library is a collection of free, reusable content for you to instantly download and u…
-
Email notification of new Aperture Data Studio releasesIn order to get notified of any new Aperture Data Studio releases, you can bookmark this discussion…
-
Data source and "Filter regular expression" - How it works?Hi, does anyone know how System -> External systems -> "Filter regular expression"…
-
Undo and RedoIn Aperture Data Studio Version 1, we had the Undo and Redo menu options while creating or editing …
-
Scheduling in Aperture Data Studio Version 1 vs Version 2Many Aperture Data Studio customers process large volumes of data. Workflows are likely to be sche…
-
Transform node in Aperture 2Hi, I'm trying to use the Transform step in Aperture 2 and am finding that, with the limited number…
-
Identification of an individual flat in a building using Address ValidateHi, I've checked the following address (which is valid with an appropriate postcode) using Address …
-
Scheduling workflows using the Data Studio REST API in version 2In v2.0 of Data Studio, the REST API has changed from v1, so this original post has been updated fo…
-
Connecting to a SAP HANA database using Data StudioFrom the Data Studio v1.6.1 release onwards, we've made it easier to connect to a SAP HANA database…
-
Date formattingI've lost the month in this date format - any suggestions? (not a lot to go on in the help here) Th…
-
SnowflakeWe have been experimenting with Snowflake technology and were wondering whether anybody has experie…
-
Setup Secure SSL using self-signed certificatesIs anyone able to provide some clear instructions on how to generate and install a self signed cert…
-
SAML anyone?Hi everyone. Our engineering team is currently working on a feature for Single sign on enterprise …
-
Sharing of useful functions to support contact data validationHi all, I've found myself using a few functions on a regular basis so thought I'd share them on her…
-
Tell us your experience in setting up and using external systems (databases/cloud storage services)To our valued customers, Being able to load data from external databases and cloud storage service …
-
Extracting titles and honorifics from names (advanced)In this earlier post I described how you might want to extract titles or honorifics from a name str…
-
Where could I find more information on how to use "Query duplicates store"?Hi, I am new to Aperture Data studio and one of my recent requirement is to use a supplied contact …
-
Quick Poll: Do you have a paid certification for a software product?Certifications seem like are a great way to demonstrate that you have the experience and technical …
-
Sign up to the latest data quality webinar "How to eliminate poor CRM customer contact data"Hi all, Experian is holding a free webinar on “How to eliminate the impact of poor CRM customer co…
-
Automated Data Tagging in v2.1In v2.1 you now have the ability to automatically tag your data using the predelivered data tagging…
-
Address ValidationMorning My Address Validation in V2 is no longer working, wont allow me to select "country&qu…
-
Data Stewardship PrioritiesWhen you think about Data Stewardship, what does that really mean to you and what do you think matt…
-
Extract Title from NamesDuring the course of the data preparation that you might be doing on names, you might have occasion…
-
Finding earliest date in a clusterHi I have multiple rows for a customer and each row has a modified on date. I want to find the earl…
-
Trim a leading wordIn this brief clip i will show you how to trim a leading word from a field. In this case i am trimm…
-
How to setup Google Big Query as an external system for pushing data into BigQuery tableHi, Did anybody try using the Google Big Query 6.0 JDBC and know how to configure the credential de…
-
Datasetdropzone directory changes in v2.1.2Hi all, I’m writing this post to inform you all on the upcoming change to the datasetdropzone direc…
-
Export directory changes in v2.1.2Hi all, I’m writing this post to inform you all on the upcoming change to the Export directory in v…
-
Harmonisation in V2.0 Data StudioHi Trying to understand the best way to get a better harmonised record, when you have multiple line…
-
Export - JDBC error - formula to ensure a column has a right lengthHi I am loading 1.9 million records back to database and l will often receive this message (part of…
-
Salesforce tables have different columns after upgrading from Data Studio v1 to v2If you've previously used Data Studio v1 to load data from your Salesforce instance, and have upgra…
-
Notification setup to trigger ScheduleHi I have set up a notification, so when a few datasets are loaded, it kicks of the schedule im str…
-
Upgrading to a new release for Aperture Data Studio v1 versus v2Up until now, we have had 23 releases for Aperture Data Studio v1. In order to upgrade from one re…
-
Tell us what we can do to improve your Aperture Data Studio administration experienceHi everyone, We have created a survey for you to share with us your opinion on your Aperture Data S…
-
Copy a space - workflows, datasets, exports, snapshots within the same serverHi At moment l have setup a space for single view of customer. Business would like to copy the full…
-
Export to JDBC - not loading but Job completingHi I have an export step that goes to JDBC database. We have another table in the database thats wo…
-
Subtotal of Dataset to Workflow - alertHi Is there away that when a dataset is loaded via datasource or dropzone into Aperture, that when …
-
Attention all V1 & V2 users...Today we have launched a new sub category, Migrating from V1 to V2, which contains posts to aid you…
-
Triggering workflow executions upon file arrival in Aperture Data Studio v1 versus v2Aperture Data Studio is commonly used for operational data quality management. This would mean that…
-
Address Validation v 2.1I am blown away by the speed of the Batch Address Validation processing on NA addresses in this rel…
-
Ensuring you always return the same duplicate ID with Find DuplicatesFind Duplicates returns consistent Cluster ID after each run. Consistency here applies to the seque…
-
Tagging - remove tagsHi I have workflows that have columns with tags. When l union because not all the columns tagged th…
-
Profiling Data for the first time and changing the underlying dataThis short video illustrates the ease with which you can define a dataset, profile the data to dyna…
-
Cleansing FieldsHi I have fields that are quite messy when l receive them. We will be going back to source and clea…
-
EdgeHi, Overnight Edge (the company default browser) has been upgraded - does this improve things for A…
-
Splitting full name - Last nameHi I have Full name fields, data is all represented in one field and l need to split this out to Fi…
-
Delta Data loads - Aperture v2.0Hi this is a follow on from the delta data loads for version 2.0. Not sure if a better way in v2.0.…
-
Address RationalisationHi all I am looking for an example of splitting an address into the different parts. I have an ad…
-
Split data from two columns - phoneshi I have a situation when l have a file that has two columns with phone data: Phone …
-
Phased deployment and secure collaboration in Aperture Data Studio v1 versus v2In Aperture Data Studio v1, there isn’t an effective way to compartmentalize objects such as datase…