Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Converting dates with ranging centuriesI have been unable to find a solution with an issue I am having converting dates in the format dd/m…
-
Data dropzone - additional columnsHi! I'm involved in a piece of work at the moment where we're using Aperture to map data in prepara…
-
Join after a filterHello, In Aperture 2.2.6.118 , when we use a join function just after a filter , we get error messa…
-
Creating backups of Aperture Data StudioI couldn't find much information in the documentation on how to create automatic daily backups for …
-
ℹ️ Removing Exact Duplicates / Exact MatchesA common thing users want to do with Data Studio is remove rows with (exact) duplicate values in se…
-
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…
-
Create our own Elements for Find Duplicates StepHi Team, I'd like to ask some questions about Find Duplicates Step. Is this step only for CONTACT …
-
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…
-
Match RecordsGood Day, I have two datasets can I match them and get the records that matches either by company n…
-
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
-
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…
-
IF then ELSE LogicCan I write IF (Some Condition)THEN (Valid) Else (Invalid) Logic in Aperture? So That in the Output…
-
Questions about Data Tagging and Profiling in Aperture Data StudioHi team, Is it possible to tag and profile multiple tables at the same time in Aperture Data Studio…
-
Parameters for Source Step in Aperture Data Studio WorkflowHi Team, We want to use the API to run a workflow iteratively using different source datasets (we …
-
Has anybody used Aperture to anonomise/create synthetic data?I have a requirement to create anonymised/synthetic data My initial thought, for the name, would be…
-
Experian Address Validation Results LimitWe are trying to integrate Experian Address validation REST API into our system. It looks like the …
-
Searching for metadata in the UI (e.g from datasets view or others)Hi, I'm working on a data discovery project that needs to identify the best sources of critical dat…
-
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…
-
Explore option on Report ObjectHi, Am using a report object for dashboard and the explorer is not showing to be able to filter
-
Single Customer View (SCV) user research interview invitationHi all, At Experian we are always looking to improve our technology and processes to give you the b…
-
Creating new schedule with cron expression ?Hi, I try to make new schedule every month for the time intervals from 10th to 15th and 25th to 30t…
-
XML filesHI, I'm trying to read selected fields from an XML file pulling out, for example, text between the …
-
How to Execute Parallel Workflows (without Custom Steps or Powershell)Hi all, The Setup: Aperture V2.2.8 on Windows Server 2012 R2 Current Situation: I have to run 8 di…
-
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…
-
Data Studio V2.0 Find DuplicatesHi Thank you for the answers around using Find Duplicates Workbench. I will investigate this long t…
-
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 …
-
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…
-
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…
-
-
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…
-
ℹ️ 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…
-
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 …
-
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…