Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
ℹ️ Importing your Datasets into Excel or Tableau using ODataYou can easily get your data from Data Studio into Excel or Tableau using OData. OData (odata.org) …
-
Changing Data Studio's default Language and Region settingI recently needed to change the default Language and Region setting used by Data Studio when adding…
-
RestApi AuthorizationHello Where can i find the <Environment external label> in order to build an RestApi Author…
-
Which search type I should be using if i want to retrieve State and City from the zip code?Hi Team, I am using Address SOAP v3 validation API and I intend to use it to retrieve City and Sta…
-
Salesforce - User connection propertiesHi all, If we add a new column to a Salesforce table and refresh the data, it doesn't bring the on…
-
Find Duplicates Language for Notepad++If you're using Notepad++ as your text editor, it can be helpful to have an interpreter to highligh…
-
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 …
-
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…
-
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…
-
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…