Aperture Data Studio
Discussion List
-
Handling data from Experian Aperture Data Studio jobsWe are getting error in the execution of Experian scheduled jobs as "There is not enough spac…
-
How is true / false field stored in Aperture?Note that the data below is business data and not PII. Issue: When I import the CSV file created in…
-
Want to pass certain input from API to the workflowi am trying to call an API from an external website my agenda is to pass some IDs that will be take…
-
Copy of FiServ Files uploaded into DA & use of the Metro2 ParserDoes anyone use Data Arc with a copy of a FiServ Metro2 File? We are setting this up as net new an…
-
Stored Procedure invoked from PostSQL of Export step is not processing all recordshi, In my workflow, I am connecting to SQL server 2012 using Custom JDBC jar (Microsoft JDBC Jar 12…
-
Date formats...Earlier today I received the below email from a customer which I wanted to post on here in case the…
-
Error while connecting to Embedded Duplicate StoreHi, I am getting error as below when I am trying to connect to the Embedded Duplicate store in my D…
-
Error while invoking stored procedure from Experian Aperture Data Studio using custom JDBC driverHi, I am using the Experian Aperture Data Studio (2.10.0.80) and have configured a custom JDBC Jar …
-
shutdown due to heartbeat?2023-04-13 08:57:06,646 INFO c.e.d.b.BatchService [Thread-0] Shutdown due to heartbeat timeout 202…
-
ADS, not enough permissions for page.user is admin to the workspace. what could possibly be the reason for her not to see the dashboard …
-
Aperture Data Studio - Find Duplicate ServersHello Community, Our organization has recently decided to use ADS for Data Quality tool and we are …
-
Keyword: Community - Data Management User Group Material 09th March 2023It was great to meet the Experian Aperture Team and fellow users last week. Just wondering if and w…
-
Future Date Check 📅 (Dynamic)Summary This package contains 2x rules: “Is a future date” and “Not a future date” (compared to cur…
-
Convert Epoch Date/Time to Standard Date/Time ⌚Convert Epoch Date/Time to Standard Date/Time ⌚ This function was inspired by this post and created…
-
📣 Join us in person at our next UKI Data Management User Group I 9th March 2023 📅I am pleased to confirm that our next UK Data Management User Group will take place on Thursday 9 M…
-
Java pid hprof crash files.Facing the issue in our dev server for Aperture Data Studio and Find Duplicates. In log I have foun…
-
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 …
-
Aperture Data Studio backups@Henry Simms , what would be the equivalent link to this according to current version. https://www…
-
Quick Actions menuSince v2.8 Aperture Data Studio has had a command palette that makes shortcuts and access to freque…
-
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…
-
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…
-
Repeating Characters 🔁Check for same character repeated This function uses a regular expression to identify records where…
-
How to copy dataset header to a row within the same dataset?Hello, I want to create an additional row on my dataset which would contain a copy of the header na…
-
Extract First Word 🥇📝This function extracts the first word in a string, in which all words are separated by space. The f…
-
Replace the word ‘NULL’ or any non-null space values with null 🔄👻This function replaces the word ‘Null’ (case insensitive) with a null value. For example, if the va…
-
Extract Last Word 💬🥉 Extract Last Word Version I This function extracts the last word in a string, in which all words a…
-
Challenge 5 SolutionsSo did you figure it out? What approach did you take? Something like this - what was your route to…
-
Aperture data studio log file locationHi, I have noticed something now in our prod servers. The log file generated for aperture data s…
-
Word FrequencyEvery now and then a scenario crops up where it'd handy to know how often a given word occurs withi…
-
Challenge 4 SolutionsSo did you figure it out? What approach did you take? You know what the results should look like, …
-
Parse Date 🧽📅Parse Date This function is designed to have flexibility to accommodate all sorts of different dat…
-
Huge HPROF file in installation folder.java_pid2376.hprof What is an HPROF file and what is it doing in my ADS installation folder. C:\Pro…
-
Challenge 4 - Cleaning product (data)Want to test your Aperture Data Studio skills a little more? This next challenge requires you to an…
-
Notifications based on emails in the dataWe have 50 service desks placing orders for customers around the country. We want to monitor those …
-
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…
-
Calculate the distance between two sets of co-ordinates 🌍️ Summary Returns the approximate distance in kilometres between a pair of geographical co-ordinates.…
-
Force workflow failure due to failing rowsIs there a way I can force a whole workflow to fail as a result of failing rows in a validation ste…
-
Enabling LDAPIn case you haven't noticed, LDAP has been introduced since Aperture Data Studio v2.0.11. Go to Set…
-
Issue with dates being read as American datesI am pulling in my source data with a column that contains dates of the format dd/mm/yyyy. When ann…
-
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…
-
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…
-
Dynamic Naming of Output FileHi, Is it possible to have a dynamic text element of the naming of an output file. I understand th…
-
Error with resuable workflow step in new workflowHi, I have created a workflow that produces an output and has been made reuseable. This workflow i…
-
👋 Introduction to the Functions Library 📂Intro This area of the Community hosts our library of re-usable functions for use in Aperture Data …
-
👪 Parse Full NameSummary The functions contained within this package are all designed to help you in dealing with na…