-
Copy dashboards between spaces
Hi, Is there a way I can copy dashboards, or their underlying charts between spaces. I am creating numerous ADS Dashboards each in their own space but with the same layout. All will point to a different dataset (always structured the same). I thought about creating a master list of charts and sharing them, then justā¦
-
Inserting a new column
Hi. Is there a way to insert a new column in a file and specify what values you want that column to contain (new values that are not in the file today)? I am working with result files from tests in PCSM and need to compare them, but the files need a unique key. I just need to create a column in each with a numerical valueā¦
-
Dataset list with refresh date information
Hello dear community, We try to list all dataset in all spaces with their last refresh date. Our Aperture version id 2.8.8 We noticed that the rest API "datasets" allow us to get in it's json response: datasets : information of dataset in spaces columns: ā¦ tables: information of dataset (rows account, name ā¦) batches:ā¦
-
Using 'Matches' functions to identify personal information (and automate the detection of this)
Following on from @Steve's discussion (here), I wanted to share some further thoughts on this subject as it's a topic that crops up quite regularly. If I have not got permissions to hold or process PII (personally identifiable information) then I'd want an automated means of flagging whether it is present in my dataā¦
-
Harmonizing step setup
Hi there, I was trying to create a priority on the harmonizing step to choose an email based on a score but it's not working. I checked everything to see what's wrong but couldn't find anything, can you help me? I am using the same rules on other fields for example to choose the most recent phone and address on theā¦
-
Matching Rules
Hi there, I would like to Match Names (Forename and Surname) we addresses, but would like to exclude initials. Ideally I want to them to match unless the Forename has only one character or only a initial, is that possible? How do I set up this? The new page is looking very nice by the way š
-
Severity Identification for New Version Upgrade
Regarding installing releases, is there a way to easily identify the severity of each release made available? For example, if a new release came out with security features can it be easily identified whether that particular release contains an Urgent update for vulnerabilities that should be installed as soon as possible,ā¦
-
Aperture on Kubernetes
Hi All, I would like to check if it is possible to run Aperture on Kubernetes ? I understand from Documentation that it does not support Multi node clusters, but is it possible to run on a Single Node Kubernetes Cluster or can I restrict it to run in just one node ?
-
Export in differents folder
Hello dear community, Is it possible to export (the result of a workflow) in different folders or sub-folders, in other words, workflows of the same space exporting in differents folders or sub folders Because today (my version is 2.8.8) allows my to export only in my space export folder: \Export\Production\space1ā¦
-
Aperture Data Studio 2.12.8, Find Duplicates 3.9.1
We upgraded today our prod servers, and now we have the same situation, settings in find duplicates .ini file get overwritten and experianmatch start storing everything in C. we changed the Ini file settings to D drive, and after that we have to rename the duplicate store to get it stored in D drive again. we don t want toā¦
-
Timestamp format for Metadata is changed
Hi We have 2.12.8 in Development and 2.12.1.16 in Production. We transferred few of our workflows from Production to Development when we had 2.12.1 version in Both Environment. But when we Transferred the Workflow we observed the Trend Charts is broken, we dig into more and found that the Stats based on the Trend wasā¦
-
š¤© Welcome to our new look Data Quality Community!
You asked for a community forum that was easier to navigate, packed with expert content and with a clear way to share ideas for improvement! Christmas has truly come early, and you can now enjoy our new look community forum with much clearer and structured categories, including categories specifically for our Experianā¦
-
Harmonizing of addresses
Hi there, I would like to understand better about the harmonizing of addresses. If I choose the best complete option as a priority, this will mix up different addresses? I have a case where an address in London was chosen but it added Oxford as this was in a extra column for an older address. Have you had this problemā¦
-
Upgrade Issue, Aperture data studio , Find Duplicates latest versions
Hi Ian, Looks like after the recent upgrade we have an issue that experianmatch path got changed to the C drive automatically, meaning it did not following the existing configuration we have which were to be this onto D drive. And even after changing the path manually on Find Duplicates ini file, it still does not updateā¦
-
Matching Results - Find Duplicates
Hi there, Any idea why in the matching results the big clusters are coming with different cluster id? When I look in the workbench they match perfectly but the results show different cluster ids. TIA Mariana
-
Has anyone noticed varying results checking domain validity of same email list a day or 2 later?
-
Equals Function - does it ignore characters?
I am using the 'equals' function to compare two fields, looking for differences. However, it seems like the function ignores special characters such as . @ < and this is causing a problem when I am trying to compare two fields so show email cleansing. E.g. says: email.address@place.com is equal to email.address@plac.ecomā¦
-
UPRN Validation
I was using the address validation function to validate StreetTown and PostTown against the UPRN on a small subset of data. For some of the records, the street town is different from Royal Mail information. For example: UPRN 1 - StreetTown: Glengolly - PostTown: Thurso UPRN 2 (next door to UPRN 1) - StreetTown: Thurso -ā¦
-
Harmonizing rules
Hi there, Can anyone help with the harmonizing process? I have a huge list with names, phone, email, addressā¦I want the most recent record in case someone change email or address but would like the system to include information that are found in other records but not on the most recent, does that make any sense? I canā¦
-
Eliminate rows with null values?
I'm in the process of generating a dataset from a snapshot, and I'm interested in recommendations for eliminating rows that contain null values in a particular column. Any advice would be appreciated.
-
Is there a Zip code validation Regex code library?
Hi All, We need to check and validate the Postal codes in our database for all the countries and I see that we have these built-in format validations for these countries: Do you know if there is a library in Aperture for regex codes to check the Postal code format for all the countries? Many thanks! Kind regards, Vera
-
Datasets - view types
Hi, is there a way to see what datasets were imported as flat files or as delimited? And for the flat files, is there anyway to adjust the metafile values or see what the metafile is? Thanks
-
API Key
Hello, We use Aperture 2.8.8 version, we've noticed that in the uat env, we can create an API key with more that 10000 days But in the prod we can not use more that 365 days I guess that it's related to the configuration. Could we know where can we extend the key duration please? Best regards
-
autoColumnMapping function in Workflow api
Hi, Have you consider having a flag in your api to execute Workflows to use the auto Mapping columns we can have in Studio ? This will be great to avoid case sensitive headers in DataSet for instance. Regards,
-
Is it possible to export a file as an XML please?
I have a set of data and would like to be able to export it as an XML. I have a solution that allows me to export a set of records surrounded by XML tags and prefixed by a sort key. The different sets of records are exported into a directory and the solution then ingests these, sorts them according to the key, strips offā¦
-
Grouping with TOTALS row?
I have a grouping of data that I have an aggregation of (sum) for various data points (about 60 rows). Could I add a final row that provides a total for each of the aggregation columns (as seen in Excel). Thanks
-
Creating Solution- Selected all spaces
Why I am trying to create a solution all the spaces where I have access have been selected automatically but I want to do with 2 spaces only. Then I am trying to deselect the other spaces but its taking forever and page is then hanging after some time. Just buffering nothing really happens after that
-
oData Driver
Hi I want to fill a Dataset on scheduled basis from an oData source, but no oData options are available in my External Systems section of Aperture. I think I need to download and configure a JDBC oData driver, or am I missing something in Aperture? Many Thanks Luke
-
Workflow is not in an executable state but no errors exist
Hi DQ Community, I have a workflow that I can't run or publish because I get error messages telling me that one or more workflow steps are invalid, or that the workflow is not in an executable state. I've been through the workflow multiple times and all the steps are valid - I can open the final step and view results, andā¦
-
Analysing dates values placed in different rows
Good morning, I'm trying to build a logic that will compare two date values and returns the comparison as a positive or negative number, the restriction is that the check has to be done within a group that have the same ID number. However, both date values are not on the same column or row (see example below). The idea isā¦
-
Replacing values with a lookup column?
Good afternoon, I'm trying to replace specific values (sample below) from a text field in a dataset, I've highlighted the ones that I was expecting to be changed on this sample; to do that I've created a lookup column with the value and the replacement (see sample below). However, when I a run the Replace Matches functionā¦
-
Can I identify duplicate customer account numbers in a file?
I have a significantly large file over 5 million records. I wanted to see if there is a way to drill down in the file to see if there are any duplicate customer account numbers existing in the file
-
Cosmos DB to Readable SQL
Hello, Has anyone yet used Cosmos db in Experian? We are trying to denormalize cosmos db into SQL; Is there a way in Experian we can transform the cosmos data to readable sql?
-
What does this column duplicate:Action mean?
The results on my duplicate step are coming with some empty gaps and when I checked it all the gaps were the Action Affected in this column. Can someone explain to me what does this actually mean? Am I missing any data or this is just an extra field and I can remove all the Affected rows? There are 2 things in this columnā¦
-
Is there a way to filter/extract certain columns from the datasets?
Hello, I'm trying to filter or separate a few columns from the datasets so, is there a way in Experian we can separate columns?
-
Autonomous REST connection SQL query
How can I get a simple SQL running when everything is set up . the Autonomous REST connection is success. But when I try to execute SQL to add new data sets, I am getting this error, and experian documentation here, has not explicitly mentioned anything how to get those running. I checked documentation there,ā¦
-
PowerBI Automated Refresh
We know how to schedule workflows to run automatically. However, once the subsequent snapshots have been produced, is there a way to notify PowerBI that the data has been updated? Currently the PowerBI developer is having to refresh the datasets manually once they know the job has completed as per the schedule.
-
SalesForce refresh failed to process query: INVALID_FIELD
We have scheduled refresh Jobs to refresh the Tables on daily basis. The Wfs are getting the status completed but the tables are actually not getting refreshed. I tried to manually refesh as well but that is also not working. This is happening when there is new column added in the tables and that tables is not gettingā¦
-
ODATA: filtering the access to a dataset
Hello dear community, Our use case is as follow: We will have a big dataset and we would like to get access into it using Odata, but we are not interested in the hole dataset, only a small part. Is it possible to apply a filter when we get access to a dataset using Odata Thank you in advance
-
Internal error
Hi there community, I am getting this error when trying to edit some workflows. I schedule some workflows to run through the night and it failed, it was a large amount of data, but since then this error is coming up. Does anyone ever been through this and know what to do? Many thanks, Mariana
-
Handling data from Experian Aperture Data Studio jobs
We are getting error in the execution of Experian scheduled jobs as "There is not enough space on the disk" We have installed the data from the Experian Aperture Data Studio on the E Drive (511 GB) out of which only 19 GB is remaining. Majority of the data is occupied in the E:\ApertureDataStudio\data\resource folder underā¦
-
Remove columns if empty
Hi! Is there a way to remove the columns which do not contain any data in a workflow step? I would like to only include columns that contain data but it may change over time and would like to automate it. Many thanks! Vera
-
Retrieving Datasets from an external system using API
Good morning, We are currently on the beginnings of a project where we need to retrieve data from an external system using API. We have develop an small script (see below) but I would like to get some advise before running it, the idea is to collect the datasets from the external system an import them to a Aperture spaceā¦
-
Error Encountered While Executing Workflow
I am attempting to manually execute a recently created workflow, but I am encountering an error. The message states that 'source 1' and 'source 2' must be provided to run the workflow, despite all my data coming from a view. I am unsure about the specific requirements it is asking for. Could someone please shed light onā¦
-
Input source filename as export filename
Hi All! Could you please let me know how can I automatically add the input source filename to the export filename in the workflow? I can get the input filename with the metadata, but how can I add somehow as a parameter to make it the exported file's name? Many thanks! Kind regards, Vera
-
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 Aperture into PowerCurve Assisted Strategy Design, it does not recognise the values in the CSV file as being text āTRUEā or āFALSEā. If I copy the values in this column and paste them into the same column as Values, then itā¦
-
Want to pass certain input from API to the workflow
i am trying to call an API from an external website my agenda is to pass some IDs that will be taken as input in the workflow and the workflow will run for those IDs only and finally if i could export the result in some kind of file (csv,excel,xml)
-
Copy of FiServ Files uploaded into DA & use of the Metro2 Parser
Does anyone use Data Arc with a copy of a FiServ Metro2 File? We are setting this up as net new and it appears that FiServ does not include the RDW in the header or the file. This is limiting our ability to upload the dataset into the tool. Has anyone had any experience with this?
-
Azure Cosmos DB Connection
Hello, We thinking to connect the cosmos db using a JDBC connection in our ADS. However, we did not see cosmos db as an option on the dropdown list in the external system setting. So, trying to see if anyone here has the answer to our question below: Do Experian ADS support Cosmos db? If Yes, has anyone here made thisā¦
-
Aperture Find Duplicates Match Status and Cluster ID Columns
Hi As my workflows grow and I'm introducing more Find Duplicate steps I've realised I need to start using transform steps to remove the Match Status and Cluster ID columns after I've finished Harmonising or Filtering on them. If I don't it can be confusing when trying to select the correct Match Status and Cluster IDā¦
-
Connecting Synapse to Experian
So I am trying to connect Experian to Azure Synapse to get DQ result. So I have tried using the JDBC SQL Server Driver (SQL Server 6.0) and in addition to this changing the customer connection string to change the Select Method from cursor to direct. However when I test connection all I get as a debug on the UI isā¦
-
Stored Procedure invoked from PostSQL of Export step is not processing all records
hi, In my workflow, I am connecting to SQL server 2012 using Custom JDBC jar (Microsoft JDBC Jar 12.2) and the connection string looks like belowā¦
-
Date formats...
Earlier today I received the below email from a customer which I wanted to post on here in case the answer is of use to others: I was wondering if you could help me overcome an issue I have been facing in Aperture. When uploading a file to Aperture through the āAdd Datasetā section, in the āDefine settingsā menu there is aā¦
-
Why would a snap shot drop all data in some columns when run as part of a workflow?
I have a workflow that acts as shell for several workflows that run in sequence (first cleaning data, the second evaluating that cleaning). I have set up a snapshot to capture the data after the cleaning to make sure everything is working OK. When I run the workflow, this snapshot does not retain the data for the originalā¦
-
Refresh a dataset from REST WS
Hi dear community, Is it possible to refresh a dataset data through REST web service ? I know that we can: 1- upload a file into Aperture through REST 2- create a dataset data using the file key But I can not see how to refresh an existing dataset data with a new uploaded file ,( I don't want to use delete function becauseā¦
-
Source Table Name on workflow coming as "SQL Query"
Hello, One of my workflow datasets is SQL query and when I pull metadata like database name, table name, and hostname; the table name is coming as 'SQL Query' instead of the actual table name. Does anyone know what is causing this issue and how do I fix it?
-
Error while running workflow
Hello, I am trying to run the newly created workflow manually and it is giving me an error. It says source 1 and source 2 must be supplied to run the workflow. All of my source data are coming from view. Don't know what it is asking for? Does anyone know what is the error about and how to fix it?
-
Harmonize Duplicate based on recent data
Is there a way to select only the recent record while doing the data merging and selecting the golden record
-
Is there a scramble function?
Hi, Is there a scramble function (much like there was in Pandora), as that feature was great for hiding PII but keeping the cardinality of values. Thanks
-
How to optimise Validation, Filter, and Take Snapshot Steps
Hey folks, Can anyone help me with optimising performance on Validation, Filter, and Take Snapshot Steps, and hopefully also provide some benchmarks for expected performance? We have several datasets that we are cleansing, and then separating into passing and failing records based on them containing enough valid dataā¦
-
Refreshing Datasets Error Message
Hi, I recently updated the credentials for an external system, and when refreshing some of the tables a few of the columns have been removed. Previously this hasn't been a problem because I can just configure the tables, but since we upgraded I've been getting the following message: Screenshot 1: Notification that thereā¦
-
Data Quality reporting over time
We have a set up here at Speedy where we have data quality split across multiple spaces. We pull all of the DQ validations out into a central space via snapshots and views to create a kind of DQ datamart which enables us to report DQ at a company level. One of the key issues we are challenged with is that users canā¦
-
REST API : getting the result of a workflow in the REST api response
Hi dear community, Would it be possible to get the workflow result in the RESt webservice call ? In orther words we want to execute the reunning of a workflow through a rest web service, then we get in its response the result (it can be a file or a content of the report in JSONformat) Thanks in advance for your reponseā¦
-
Google Forms as a source
Hello, I hope you're fine :o) I'm wondering if Aperture could take Google Forms as an input source, in order words if it can consume Google forms Thank you in advance. Best regards Ali
-
What does error 4002: Output column does not appear in input mean
I can't see why this error is being produced. the grouping step has all the data required to create the output.
-
Workflow triggered via datadropzone - Dynamic Source in Workflow
I see that a source in workflow can be defined as dynamic and we can pass the source name when running online or running thru schedule. But when running thru notification (Verion 2.8.8) , I see no option to pass the source parameter. Has anyone found any solution for this?
-
Workflow inside workflow
Hey community, I am trying to get one workflow to run 2 workflows inside itself. In one workflow there are several functions to clean the data and on the second workflow I have other functions to evaluate the data. How can I make this happen without the need to put the source again inside the cleaning and evaluatingā¦
-
Labelling rows based on Grouping
Is there an easy way of labelling rows based on a grouping step? in my source data of roughly 25,000 rows, I have 2 validation columns; valid email and valid mobile number, populated with true and false. When grouped they form 4 categories; FALSE FALSE, FALSE TRUE, TRUE FALSE, AND TRUE TRUE. What i want to do is mark eachā¦
-
Help with Blocking Keys for Phone Numbers not generating results
Hi all, I'm trying to create two blocking keys for phone numbers, one that works off the first 5 digits, and one that works off the last 5 digits. I've tried several variations of this both in with other blocking keys and now on their own, and they are not generating any results, can anybody help with suggestions of whereā¦
-
Using workflow'(s parameters
Hi dear community, I'm using Aperture 2.8.8 verison My use case is calling a workflow through REST and I need to provide some data as input (always in REST) in order to execute the workflow with these data. I'm thinking about using data as workflow parameters, then inside my workflo I will use these data and add them in aā¦
-
Profiling multiple dataset
In the Latest version I see there is an option of using multiple datasets in Profile and use all columns. Is there any documentation how to use it as I can not use multiple dataset in the same Profile Transformation
-
Pushdown processing on Experian ADS
Hello, We are trying to improve our workflow using "Pushdown processing" so, please someone can give me more detail on when "Pushdown processing" will be available on Experian ADS?
-
How long can/should the "Analyze blocking keys" function take?
Morning all, I'm getting up and running with the find duplicates feature and have created my own blocking keys and matching rules now which are producing good results for the clustering, however when I try to analyse it in "Find Duplicates Workbench" the "Analyze blocking keys" tool is taking an extremely long time toā¦
-
How do I find if there are any duplicates across 15 different columns?
Hi, I'm looking for a quicker/easier way to compare data across 15 columns and let me know if any of the data appears more than once. There are a lot of nulls across all columns, which an equals function would say are a match, however i don't need to know about the blanks. I have done it previously through transform andā¦
-
Error while connecting to Embedded Duplicate Store
Hi, I am getting error as below when I am trying to connect to the Embedded Duplicate store in my Data studio server(2.10.10). Please let me know if you have faced similar issue and help me with the steps to resolve this. PS: We do have a remote duplicate store(3.8.15) which is working fine and we have secured the Dataā¦
-
Error message when trying to define settings of a external system table
Hi, We have connected one of our systems with Aperture, the connection is sucessfull and I can see 220 tables but when trying to go through the define seetings step I'm receiving the following error message. [ApertureDataStudio][SQLServer JDBC Driver][SQLServer]Invalid object name 'table name' Is that an error produce by aā¦
-
How do you set up a custom event to trigger when a cell value exceeds a set tolerance?
Hi all, I have a workflow which is currently producing the below output: I'd like to set up an automation whereby an email is automatically sent out once the value exceeds 100. Can anyone provide guidance on the best way to do this? I've had a flick through other Community posts and it appears that the best option would beā¦
-
Merging columns
Hi there, I am trying to fix a problem with telephone and mobile columns, the numbers are mixed up in both columns and I already separated them creating other columns, my question is. Can I merge to columns to put all mobile and phone numbers together?
-
How to create an output file that is FB (fixed-length blocked)
I can create an output file in MS SSIS that when it gets placed on the mainframe, it is record format FB (fixed-length blocked). When I perform the same output action in Aperture, the file is a VB (variable-length blocked) file. Any suggestions? Thanks
-
How do you compare 2 columns to locate and filter out duplicates?
Hi all, If I want the values in Column A & Column B to be identical, what step do I need to put in place to compare the 2? Ultimately I want a step at the end of the workflow that filters out where both columns have matching values and are complete, and returns any rows with a null value or differing values between A & B.ā¦
-
How to view entire columns data from each steps of workflow?
I have transforms, Group, and Filter steps on my workflow. And I'm concatenating four columns to create unique identifier columns. But when looking at the concatenated columns it is not displaying all data from each row and which made me think maybe data is getting truncated during the concatenation process. So, I copyā¦
-
Aperture Data Studio and Find Duplicates Upgrade
@Ian Hayden , we have issue with our upgrade on DEV, Find duplicates is not working. We need your response, I have sent you an email as well. First we ran into LDAP issue, I resolved it according to steps you mentioned, Then, with FD, we are unable to test.
-
How to auto updated datasets when definition changed?
Hello, Is there a way to automatically change the dataset definition when the external table changes? One of the datasets failed to load fresh data last night because the column definition changed.
-
Error while invoking stored procedure from Experian Aperture Data Studio using custom JDBC driver
Hi, I am using the Experian Aperture Data Studio (2.10.0.80) and have configured a custom JDBC Jar for adding Microsoft SQL Server Driver to query On premise SQL server(Microsoft SQL Server 2012 (SP4-GDR) (KB4532098) - 11.0.7493.4). With this driver, I am able to perform DML SQL queries like Select, Insert and Update.ā¦
-
Counting repeated values in a Column
Good afternoon, Looking for a function that counts the number of times a value appears in a colunm and returns the number of that particular repetion as a number. see example below Many thanks in adavance fo the support. Best regards, Marco
-
DR for Studio VM & Duplicate Store VM
We have 2 Azure VMs- one with Aperture Data Studio Version 2.10.0.80 and another with Find Duplicate Workbench version 3.8.10.001. Both are up and running. As part of our backup strategy, we have implemented the following: We have kept the latest versions of all of our spaces ( dmx files) in a version control system Weā¦
-
Export as fixed length?
Hi, I want to export data that will be going to our mainframe. The data needs to be a fixed length format though, so fields will need to be padded with spaces for the whole column length. is there any easy way to do this before I start looking into building my own functions? Thanks
-
Can workflows be accessed/edited in another space once shared?
Hi all, I've published a workflow in 'Your Space' and have set it to be shared with other selected spaces with the intention of exporting the data via OData Feed and into PowerBI ('Your Space' can't be updated to allow publishing to ODBC and OData). However, when trying to access the workflow from the new space it isā¦
-
Can we create a Dropzone folder where we can use multiple files?
Currently we can create One folder Per Dataset where I can use only one file to be uploaded. Can we have a folder in Dropzone where I can Place Multiple files together in the same folder? As this is now Dataset specific folder so is that be possible now to load multiple files?
-
Parameter as a list?
Hi, is it possible to have a parameter use a list? So the same workflow gets run for a list from an input file? I have a report that I want to run, many times over based on a a county name from a list. Right now, I have to change the parameter manually. Thanks
-
Migration of workflows containing links to Functions
Hi I have created several Functions and included these in a Workflow which has been tested in our DEV environment. However, after migrating (using Export/Synchronise) both the Workflow and associated Functions to our PRD environment i have had to re-add all the functions into the workflow again (and subsequently reassignā¦
-
Email domain validation
Hi there, I don't seem to find the function that validates email domains, can someone help, please?
-
Aperture British Summer Time (BST)
Hi, There may be a very simple answer to this question, but is there some way of getting our Aperture to recognise that we are now in British summer time? On our jobs tab everything is currently showing an hour earlier than it is, because it's still set to GMT. Thanks! Rachael
-
Migrating Workflow
Hello, Everyone, We are going to install the latest version of Experian Data Studio on our brand-new server. Does anyone know how I can migrate workflow from the old server to a new server other than manually exporting and importing to the new server?
-
Why this function is not working when using replace matches?
Good afternoon, Could you please help me to undertand why the following function isn't returning the desired outcome. Here is the what it should be doing: Looks if the combination of two columns have a match between the tables i.e. Iām using the match table 1 - Job title/table 2 - position name and table 1 - jobā¦
-
A function to identify and remove multiple spaces between words
Good morning, I've build the following function to identify and remove multiple spaces between words, however it is not working. Am I missing any step? Many thanks in anticipation for our support. Best regards, Marco
-
shutdown due to heartbeat?
2023-04-13 08:57:06,646 INFO c.e.d.b.BatchService [Thread-0] Shutdown due to heartbeat timeout 2023-04-13 08:57:16,218 INFO c.e.d.b.BatchRunnerProcessMonitor [batch-client-system-akka.actor.default-dispatcher-5] *** Batchrunner process terminated 2023-04-13 08:57:16,218 WARN c.e.d.b.BatchClientActorā¦
-
Evaluation of Address Validation with API
Does anyone know if Experian ADS can handle our requirement below: Functional Requirements Standardization Address Standardization (MUST HAVE) - Some level of correction, modifying address portions such as STREET to ST. Taking addresses from multiple systems and standardizing them into one. Matching (MUST HAVE but can beā¦
-
Wrong column problem
Hi there, I have a lot of data that is correct but in the wrong column for example, phone numbers on the lastname column, any idea on how to fix this?
-
Cleaning Function
Hi there, does anyone know a function to clean whitespaces but leave one space between names? The equivalent of TRIM in excel. Thanks š
