Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
How to assign a variable value to a new column created in TransformI am creating a new column (X) in Transform and I want to assign the value I created in the previouā¦
-
How to assign a variable value to a column valueI want to assign the value of a column to my Workflow Parameter value. Ex. I have list of the columā¦
-
Can I integrate Aperture with CollibraIs it possible to Integrate Aperture to Collibra? And then showcase the Rules created in the Apertuā¦
-
Can I Consume API in Aperture?How can I consume API in Aperture or how can I read/parse XML or JASON in Aperture
-
IF then ELSE LogicCan I write IF (Some Condition)THEN (Valid) Else (Invalid) Logic in Aperture? So That in the Outputā¦
-
How do we expand on the provided base blocking keys and rule sets on Aperture Data Studio?Hi team I am asking this question on behalf of one of our Credit Services team members. They are loā¦
-
ā¹ļø ļ»æ Scoreboard Charts for DashboardsCharts can be created as bar charts, line charts, pie charts etc. These charts can be collated togeā¦
-
Notifications in Aperture - email contentHi everyone! I have a question related to the email content on the notifications section. We are trā¦
-
Salesforce - User connection propertiesHi all, If we add a new column to a Salesforce table and refresh the data, it doesn't bring tā¦
-
Find Duplicates Language for Notepad++If you're using Notepad++ as your text editor, it can be helpful to have an interpreter to higā¦
-
šŖ Parse Full NameSummary The functions contained within this package are all designed to help you in dealing with naā¦
-
Offensive Words š¤¬Summary The functions contained within this package all relate to flagging and dealing with data coā¦
-
Mask Out Email/Phone š”ļøSummary This package contains 2x functions to help with anonymising certain input values, whilst leā¦
-
Proper Case Surname šSummary This package contains 2x functions which help with contact data: Proper Case Surname and Vaā¦
-
Get Word āļøGet Word Extracts the 'nth' word from a string (where 'n' is defined when the fā¦
-
Reasonable Date of Birth (DOB) šReasonable Date of Birth (DOB)Ā [Category: Validation] This function simply checks the input seems rā¦
-
Standardise Gmail addresses š§Standardise Gmail addresses [Cleansing] This function is used to help standardise Gmail addresses fā¦
-
Job Title Match Key šØāš¼š©āš¼Job Title Match Key The function in this post has been designed to help illustrate an approach (andā¦
-
Invalid Character for Names ā¹ļøSummary This package contains 2x functions: Contains Only Valid Characters for Names & Containsā¦
-
Convert Boolean ā āConvert BooleanĀ [Category: Conversion] This function converts a binary or Boolean values (i.e. trueā¦
-
Contains Non-Latin Characters šÆContains Non-Latin Characters [Validation] This function identifies the presence of any characterā¦
-
Reverse String āŖReverse String If you find yourself needing to reverse a string (i.e. for bespoke building of anonyā¦
-
PCI Detection š³ (Payment Card Information)Summary The following package is used to detect payment card information (PCI) and whether it is prā¦
-
SIC Conversion š·ļøSummary The following package is used in processing Standard Industry Classification (SIC) codes, aā¦
-
Challenge 3 - It's a Date!This latest challenge is all about dates. The sample dataset highlights a common challenge many of ā¦
-
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ā¦
-
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 tā¦
-
Using Format Phone NumberI was wondering how everyone uses the function Format Phone Number in Aperture. For myself, I am toā¦
-
Challenge 2 - Title Casing SurnamesDoes it bother you when you get mail through the letter box and your name is not presented with āstā¦
-
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ā¦
-
Attention all V1 & V2 users...Today we have launched a new sub category, Migrating from V1 to V2, which contains posts to aid youā¦
-
āļø Challenge Index šEach month we're posting a new challenge for you to have a go at to test your data skills. Chaā¦
-
Challenge 1 - Gender Title Mismatch DetectionThis first challenge is concerned with identifying records that are displaying inconsistent informaā¦
-
š How to respond to challenges šGuidance When you've successfully completed a challenge. Make sure you post your solution so oā¦
-
Open Data Sources by CountryA few open data sources. Feel free to add more. United States: http://www.data.gov/ Austria:Ā httā¦
-
š” Submit a challenge idea š”We love to hear challenge ideas from our Community members, so if you have an idea that you think wā¦
-
Function to calculate the number of working days between two datesRecently I wanted to create a function in Data Studio to calculate the number of working days betweā¦
-
How to systematically sample with a fixed sample size and varying population sizeI was recently asked how to build a Data Studio workflow that would output a systematically sampledā¦
-
What is the status of data catalog integrations, for example Collibra?What is the current status of Aperture to Collibra-integration? https://marketplace.collibra.com/prā¦
-
Community guidelinesWe welcome you and your views in our community! We want to make this a positive, safe and vibrant pā¦
-
How to earn points, badges and to increase rankThe Experian Data Quality Community isn't about the volume of discussions and questions but abā¦
-
How to register and manage your accountYou need to register to post and comment, but donāt worry - it takes a couple of minutes. ClickĀ Regā¦
-
Welcome to the Experian Data Quality Community ļ»æ š ļ»æWelcome!Ā At Experian, weāre extremely proud of our data quality solutions, and we've set up tā¦Pinned post Read only 183 views 0 comments 0 points Most recent by Tanj Jagpal Welcome to the community
-
Using a network path for the server import or export directoryIt may be desirable to have Data Studio v1 or v2 import and export data from a network path. This wā¦
-
Handling Gmail email addresses for duplicate identificationThe problem: Gmail allows multiple e-mail addresses for a single account With over 1 billion activeā¦
-
Scheduling workflows using the Data Studio REST APIAperture Data Studio is intended to be invoked from third party schedulersĀ , likeĀ Windows Task Scheā¦
-
Data Studio v1.6.2 is now available!This maintenance release resolves several issues caused when executing workflows using the RESTĀ APIā¦
-
Approach for Matching Product data (product description)Yesterday @MiteshKhatri @Akshay Davis @Katya Jermolina and I were having a discussion about approacā¦
-
Partition Values (Dynamic SQL Partition Row Number)A question that's cropped up for a couple of clients recently is how do I segment my data and ā¦
Categories
Popular tags
- Release notes 232
- Aperture Data Studio 167
- Functions 64
- Find Duplicates 59
- Datasets 50
- Workflows 47
- REST API 37
- Data Studio 33
- dmx 26
- feature demos 26
- JDBC 24
- tips and tricks 23
- Automations 20
- Rules 19
- validation 19
- Validate 17
- Transform 16
- v2.14 15
- datasource 15
- Notifications 15
- Community Challenge 15
- v3.1 14
- Downloads 14
- v2.8 14
- v2.12 14