Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Email notification of new Aperture Data Studio releasesIn order to get notified of any new Aperture Data Studio releases, you can bookmark this discussion…
-
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…
-
How to convert unix timestamps to human-readable date?Hi, Does any one know how to convert Unix timestamps to human-readable date? Example Unix timestamp…
-
Many to many lookup of matching wordsI have a table which I'm treating as a lookup table. It's format is something like. Key Value …
-
Convert Pass and Fail to 0 and 1Hi, Is the a quick way to transform Pass and Fail validations to numbers 1 and 0 respectively Regar…
-
4009: Exception occurredWhen filtering on a field I get an error 4009: Exception occurred
-
Using token authentication in SOAPHi, Up until now we have been using the username/password authentication in our SOAP calls, but we …
-
XML driver for ApertureHi, Does anybody on the forum know if it is possible to read semi-structured XML data into Aperture…
-
Importing DataSets - Filtering DataHi, I was wondering if there is currently anyway of limiting/filtering out data from an underlying …
-
-
Data Studio V2.0 - Trend Analyse & Data Consumer DashboardsHi On the help documentation, there is no update on Trend Analyse and Data Consumer Dashboards If t…
-
Consumer Users, Reports and Scoreboard ChartsThe Chart step has had several improvements in the past few months, most recently a new chart type …
-
Notifications in Aperture - email contentHi everyone! I have a question related to the email content on the notifications section. We are tr…
-
Calling subroutinesHi, When there are more that 1 outputs from a subroutine is it possible to distinguish them in the …
-
Aurora database connection?Hi, Our client MDM has been built on an aurora database platform. Is there a connector for Aperture…
-
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 …
-
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…