Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Remove rows that have null value?I'm creating a dataset from a snapshot and I would like to remove rows that have null value on…
-
Not been able to drill down from a view created from profile data stepI've created an interactive view from the profile data step however, after publishing the view…
-
Low Disk Space Notifications and others.Hi team, this is to ask you if I create a low disk space notification on aperture data studio syst…
-
Setup Secure SSL using self-signed certificatesIs anyone able to provide some clear instructions on how to generate and install a self signed cert…
-
APIs to get the details regarding Data set and wf schedulesHow do I get Information about all the datasets refresh which have been scheduled and timing of tho…
-
Find Duplicates Training DataAttached is data to be used with Find Duplicates Training.
-
How to validate US dates stored as YYYY-MM-DDI have several fields that have dates stored in the format above. If I run the built in function &q…
-
Aperture API to get the health of the system CPU UsageCan we get the health of the environment through API? What is TenancyID? how can we get the CPU us…
-
Issue with Views when upgrading to v2.6.3, v2.6.4 and v2.6.5We are aware of an issue that affects some installations of Aperture Data Studio versions 2.6.3, 2.…
-
Critical vulnerability in Apache Log4j libraryOn 9th December 2021, Proof-of-Concept exploits for a new critical zero-day vulnerability affecting…
-
Importing DataSets - Filtering DataHi, I was wondering if there is currently anyway of limiting/filtering out data from an underlying …
-
Installation of Find Duplicate Different InstanceCan you please help me with the instruction link for installing Find Duplicate Workbench a separate…
-
Aperture compatibility with .NET 4.8Hello support team, I hope you're fine. We need to do an upgrade to .NET 4.8 According to this…
-
Drop zone configuration in server.propertiesHi Team, Can we configure customize datadropzone folder at different shared location same as export…
-
Filtering Data on loadIs there a feature in Data Studio to filter data from an external system load - i.e. Select X from …
-
Dashboard Custom content widgetThe Dashboard Custom content widget allows you to add information such as text and links that might…
-
📽 📺 Achieve more with your data - videosOn the Data Studio homepage there is a widget named 'Achieve more with your data' that gi…
-
Next ⏭️📅 & Previous ⏮️📅 Working DaySummary The 2x functions contained within this package relate to identifying the last working date …
-
Last day / working date of month 📅Summary The 2x functions contained within this package relate to identifying the last date of the m…
-
Finding database / table attributesHi, Is there a way of creating an output of all the fields and attributes of a table / database. I …
-
finding previous day recordHi, I have a file of daily transactions where I find details of the latest record using Max date. H…
-
Calculating the difference between values on separate daysHi, I have created a grouped output which counts the number of loans per day as below. How do I cal…
-
Connecting to D365 with OAuthCan someone tell me what the settings are for the below when accessing D365 Authentication paramete…
-
How to promote from dev to prod environments when using different external systemsProblem: I’ve recently been working with a client who had used their Data Studio development enviro…
-
Migrating Aperture Studio from one VM to anotherHi, We are trying to migrate Aperture studio installation from 1 virtual machine to another. Could …
-
REST API: get dataset list and their informationHello, We are looking to identify all datasets (of all spaces) that are in autorefresh. When we use…
-
Find Duplicate - Based on different criteriaHello, Requirement is find the duplicates based on 3 different criteria - Name and Phone Match Na…
-
How to do pivot Column to rowsI have rule1, rule2, rule3 in the column names and corresponding count in the rows, now I want to g…
-
Manual review of Find duplicates clustersUsing a similar approach to that covered in an earlier post we demonstrate a method for manually re…
-
Snapshot build taking nearly an hourHi - I have a table of approx 25m rows looking up to 2 other tables to retrieve 2 values. I then ha…
-
ODBC: connection failledHello, We are facing some issues when we try to apply ODBC procedure (https://docs.experianapertur…
-
Replacing the string value with Null if the end of the string matches with the LOVI have company names in a field I want to replace the end of the company name with Null if the name…
-
Dynamic DataSet NamingHi, We are trying to use Aperture V2 as part of the ETL workflow. We need to pick the data set from…
-
Does Aperture has the feature of Fuzzy Matching on Name/Company Name?We do have company names but it is maintained in different system in a different way. in One system…
-
Error when running workflowWhen running a workflow I get the error message - One or more workflow steps are invalid - but no i…
-
Aperture Data Studio Hosted and Managed Service Maintenance ScheduleFor our customers on the Aperture Data Studio Hosted and Managed Service: The maintenance schedule …
-
How to Capture Trend of the DQ ScoresI have rules created and I have scheduled the rules to run on every weekend. Now how can I capture …
-
👋 Introduction to the Functions Library 📂Intro This area of the Community hosts our library of re-usable functions for use in Aperture Data …
-
Do we need license for the Data ConsumerWe have many Business users and want to give them only read access to the reports so we just want t…
-
How to get distinct value from a columnex I have company value in a table with contact details one company has multiple contact and now I …
-
Data dropzone - additional columnsHi! I'm involved in a piece of work at the moment where we're using Aperture to map data …
-
Join after a filterHello, In Aperture 2.2.6.118 , when we use a join function just after a filter , we get error messa…
-
ℹ️ 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…
-
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…
Categories
Popular tags
- Release notes 226
- Aperture Data Studio 166
- Functions 64
- Find Duplicates 59
- Datasets 47
- Workflows 46
- REST API 37
- Data Studio 33
- feature demos 26
- dmx 26
- JDBC 24
- tips and tricks 23
- Rules 19
- Automations 19
- validation 18
- Validate 17
- Transform 16
- Community Challenge 15
- Notifications 15
- v2.14 15
- datasource 15
- Downloads 14
- v2.12 14
- v2.8 14
- Extensions 14