Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
🎞️ Here is a short demonstration video on sharingIn this video I will show how different types of user role and license assignments have different a…
-
Storage DetailsCould you please confirm me that if we can get the below details from Experian server. how much dat…
-
4Apply Filter memory functionality to Custom Events screenIn the Workflows, Datasets and Automations screens, users can use the Search box to filter and find…
-
Export to Excel and Format OptionsHi, when I export to an Excel file, I have a column that I want to be shown as a number format. In …
-
Error attempting to delete match storeHi, In my project, we are using Experian Aperture Data Studio(2.10.10) to connect to a Remote Find …
-
Connecting to Salesforce with OAuth2Data Studio uses a JDBC driver to connect to Salesforce, allowing data to be extracted, transformed…
-
Use a value in your data as the export file nameIf you are looking to use a value in your data as the export file name, you may have looked at the…
-
Challenge 6 - Postcode FormattingThis challenge came from a question that I was asked recently. The user had a column of UK postcode…
-
Scheduling in Specific Time frameHi, Is it possible to schedule my workflow once in a hour from 8:30 am to 8:30 PM? I can see the op…
-
How to repeat a single value for each row?Hi, I have a table, that could have any number of rows from 1-60. I want to add a new column that d…
-
Invaid Remote URLWe have renewed the SSL certificates for the aperture data studio servers successfully and we have …
-
Issues with Dev Environment Post-UpgradeI'm reaching out to address some critical issues we've been encountering with our Dev environment f…
-
Use a View in the Map to target stepThe Workflow step Map to target allows the schema (column order and column names) of a table of dat…
-
Data Management User Group 6 March 2024: Recap and reflectionsA note from Sarah Williams reflecting on the Data Management User Group that was held on 6 March 20…
-
Function details through the API?Is it possible to get a list of functions via the API, similar to how the List Datasets call works …
-
Mirjam Schuke: Senior Product ManagerHi everyone, I started as a Product Manager for Data Studio at the end of 2022 and am therefore sti…
-
How can I transform multiple columns at once?This questions had been asked by a user of Data Studio so I'm posting it here for anyone else looki…
-
Unable to connect port from the aperture data studio serverHi Team, We have installed the aperture Data studio and Find duplicates in to the two different ser…
-
Managing Data Quality issues using Issue listsIssue lists allows Users in the same Space (including read-only Consumer users) to capture problema…
-
-
Using Github connection?Hi, Anyone using Github connection to/from Aperture? If so, for what kind of purpose(s)? @Josh Boxe…
-
third party data for use with Facebook adsSeeking a solution where I can build simple audiences – age 50+, US residents, household income $55…
-
Compare two data sourcesThe Compare step allows you to detect and highlight differences between two data sources, e.g. year…
-
Seamus Kyle: Data Quality AdvisorHello, I've been at Experian Data Quality for over 10 years now. During that time I've been a Consu…
-
Error Message 4020: A batch error occurred: Data file has expiredHi community, does anyone knows what does this error means?
-
Error Message : 4022: Input columns different size to output columnsGood morning, I'm trying to get outputs of a particular workflow, see image below, but it fails and…
-
Email notification for job failure and successHi Team, We need to set up batch alerting for both failure and success for the below email addresse…
-
Load Excel and select/deselect worksheets?Hi, Is it possible when loading an Excel file, to select only specific worksheets to load? I tried …
-
Are Views Materialized?Hi, just wondering whether views are materialized (and only updated when underlying data is changed…
-
Duplicate Store / WorkbenchHi there, my duplicate store is generation very big clusters and I am struggling to find why is thi…
-
-
Refresh dataset notificationHello dear community, my use case is: we refresh more that 200 dataset ( from SAP source) in the s…
-
Is there a way to bypass the QAS validation for certain profilesHello, I would like to ask if there is a way for certain profiles not to go through the validation …
-
Address Validation & Cleansing@Seamus Kyle Hi Seamus, We have a requirement, where we know the Invalid Address and we want to co…
-
Group in Validate stepIs it possible to Group in Validate Step. My Goal is to get the Data Along with the Stat example I …
-
Matching RulesHi there, On the duplicate step when we change the matching rules I wonder if two records are empty…
-
1Creation dateAdding the 'Creation date' in the objects listing (workflows, functions, etc) would be a very usefu…
-
Aperture Data Studio CertificationIs there any Official Data Studio Certification?
-
Workflow creation date?I know we have the 'Modified' field listed on the workflows page. Is there a way to see the actual …
-
-
Best practice for testing only numbers in alphanumeric fieldHi. I am looking for the communities thoughts on best practice for testing only numbers exist in al…
-
Snowflake ExportHi Everyone, We just upgraded to the latest version (2.13.2.35) but have been having trouble export…
-
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 …
-
What Foreign Country Code should be used for AS and MP so not to fail the Foreign Country Code Rule?We have fails under the Data 360 rule Foreign Country Code Is Not Reported rule. AS, which refers …
-
Show & Tell requests for: 6 March 24 - Data Management User GroupHello Aperture Data Studio customers, In our next User Group event that we hold twice a year, we’re…
-
Moved: What Foreign Country Code should be used for AS and MP so not to fail the Foreign Country Co…This discussion has been moved.
-
How to look for ID's in the same column without using Group and Latest date with filteringHi @Danny Roden , I have 2 scenarios i wanted to run past you to get some advise, please: I have a …
-
Finance Format Number 💲Summary This package contains a single function but may be updated in the future to include others.…
-
Percentage functions 🧮Summary This package contains a couple of functions but may be updated in the future to include oth…
-
📋 Index of reusable Functions! 📇This post simply acts as an index for all the functions shared in this library. If you would like t…
Categories
Popular tags
- Release notes 190
- Aperture Data Studio 154
- Functions 61
- Find Duplicates 59
- Datasets 41
- Workflows 39
- REST API 35
- Data Studio 33
- feature demos 26
- dmx 26
- tips and tricks 21
- Rules 18
- JDBC 17
- v2.14 15
- Community Challenge 15
- Automations 15
- datasource 14
- Transform 14
- v2.8 14
- Extensions 14
- v2.12 14
- Downloads 14
- validation 13
- v2.11 13
- export 12