Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Java pid hprof crash files.Facing the issue in our dev server for Aperture Data Studio and Find Duplicates. In log I have foun…
-
ℹ How to track DQ issues with Issue listsIssue lists allow you to capture problematic records, assign them to stakeholders and collaborate o…
-
Issues Lists - notificationsHi everyone, I'm looking at setting up some issues lists for the first time, and I have a question …
-
🎞️ A short video demonstation on using the Quick Actions bar, shortcuts and moreSince Aperture Data Studio 2.8.0 users have been able to use the Quick Actions bar to access freque…
-
Replace Matches function returning custom columns?Hello. I have a large table in which I would like to replace certain values with a lookup from a st…
-
Test if field contains only white spaceHi, I am still new to ADS. I have fields that contain just white spaces (1-3 spaces in a row [&quo…
-
Rename Widget without Renaming the View/ChartHi, is there a way to rename widgets in a dashboard without changing the name of the view/chart/dat…
-
Java Update - Vulnerability detected on our Experian Dev/Prod ServerThis version has been detected as vulnerable by - OCPU-2022-JUL: Oracle Java Critical Patch Update …
-
Join us Online for our next Data Management User Group | 15 September 22 !I am pleased to confirm that our next UK Data Management User Group will take place on Thursday 15 …
-
Can we add a hyperlink to the e-mail notification?Hi! Is it possible to add a hyperlink to the e-mail notification? It would be a nice feature to be …
-
Is it possible to have dtill down in Charts /TrendI have trend where I am showing some stats based on the month , I have also information available b…
-
Row to Column after validate stepIf I am using row to column step after the validate step then using Sum to remove the null and get …
-
Adding datasets from database viewsHi, I'm currently uploading datasets in Aperture from a SQL database, a total of 15 tables were ing…
-
File name as a parameter in exportHello, I hope you're all fine :o) In a workflow, we use a dataset (which has as source a file), l…
-
Using Columns-to-Rows before a join.Hello. I'm using version 2.8.8.27 and have encountered the following phenomenon. When using the Col…
-
How to identify blocking keys for Find DuplicatesBlocking keys identifies records that are similar, creating blocks or potential groups of matches. …
-
Aperture Data Studio backups@Henry Simms , what would be the equivalent link to this according to current version. https://www…
-
how to find Dataset & External Systems dependencyI tried with API to get the list where I can find the list of the Datasets along with the external …
-
How to delete Duplicate external systems and tag dataset with the actual oneHow to delete Duplicate external systems in a space and then tag datasets that belongs to that exte…
-
Snowflake Issues with Dataset CreationWe have deployed the proper snowflake drivers and have successfully connected to a hosted warehouse…
-
Dynamic SQL statementI've set up a re-usable workflow. I'm trying to set up a dynamic SQL statement to execute in the pr…
-
Can I create Interactivity Snapshot when unioning multiple Profiles from different datasetsHi, I am new to ADS. I want to make a dashboard a single widget, the widget would be the profile …
-
How-to Video clipsHi Are there any plans to create any more 'how-to' video clips? And if so, can these be stored in a…
-
Aperture Data Studio quarterly newsletter – October ‘22What’s happening? Aperture Data Studio will soon be been updated to v2.9, with notes and downloads…
-
Connecting to a database with a different schemaIs there a setting that needs including to be able to pull data from a different schema from the sa…
-
How can I configure TLS for the Find Duplicates WorkbenchWhat are the steps to configure an SSL certificate for the Find Dupes Workbench site? I already hav…
-
Quick Actions menuSince v2.8 Aperture Data Studio has had a command palette that makes shortcuts and access to freque…
-
Validate Email Domain. Accuracy?Hi, I have the validate email address (domain) function up and running, but I am not sure about the…
-
SSL certificate about to expire. need to apply the new one.Data Quality user documentation | Security (experianaperture.io) This documentation for applying SS…
-
Load All Columns as Alphanumeric overridden when loading Excel Workbook with multiple sheetsWhen loading multiple worksheets from a single Excel workbook, the columns are auto-converted rathe…
-
Workflow - Export to Dataset, then RefreshWe have a workflow that is compiling some results from several steps (into a union), and then expor…
-
The Group in the pivot seems not working perfectlyThe group in the pivot is not working perfectly and it is not arranging the values into columns as …
-
Can we schedule Reporting Jobs from Aperture?Is this possible to trigger the Jobs in Reporting from Aperture Ex. Power BI Qlikview Ex. after a …
-
Calculating values from N number of columnsHello. I have a dataset which contains Keys, some additional important data I'd need to keep and th…
-
Incrementally Loading DatasetsI've thought through a few different ways that I can use to incrementally load a dataset using batc…
-
Is there an easy way to filter out records which contain a number only (for a given column)?I need to filter out records which contain a number only from an address column. I have attempted …
-
Error GroupsIs there any way, having set up a number of Error Groups in a workflow, to propagate these into ano…
-
Error when refreshing dataset - "Unable to get tables."I've not seen this error before and I'm unsure how to resolve other than dropping and recreating th…
-
Batch timestamp formatI've created a number of DQ outputs running of a scheduled workflow to create a multibatch dataset …
-
Challenge 5 – Fibonacci Sequence to XThe Fibonacci Sequence is the series of numbers 0, 1, 1, 2, 3, 5, 8, 13, 21, 34,.... The next numbe…
-
Why doesn't the Replace Matches function work in some specific cases?I am trying to use the Replace Matches function within Aperture, using the Comma Separated Input Ty…
-
Why can't I select a file from an SFTP serverI am trying to Add Dataset from an SFTP server and can see a list of 29 files. I am at the Select …
-
-
Version 2.7.5 Delete dataset bugWe identified a bug in version 2.7.5. When trying to delete a dataset, the confirmation screen ask…
-
Created date columnsCreated date columns. They converted to alphanumeric. When I try to perform a compare date/time o…
-
Datasets not refreshing automaticallyHi, We built an integrated set of schedules and workflows that allows data from existent datasets t…
-
Does Aperture have the "treat leading zeros as alphanumeric" option that Pandora hadOne a a global setting that instructed Pandora to treat any input field with leading zeros as alph…
-
Select first three records in each clusterHi After running a Find Duplicates step at individual level I can see that we have many contact nam…
-
Repeating Characters 🔁Check for same character repeated This function uses a regular expression to identify records where…
-
Function for similar charactersHello, I would like to create a function that will show as "false" when a column (E.g. co…
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