-
Manual match cluster refinement - Update
I'd like to share some progress we're making with Data Stewardship or as we're calling it, "Cluster refinement" for data matching within Aperture Data Studio. We've been told by a few of you that it would be a very useful capability. The original post on the community ideas board can be read here. The improvements we're…
-
Aperture Data Studio Hosted and Managed Service Maintenance Schedule
For our customers on the Aperture Data Studio Hosted and Managed Service: The maintenance schedule is now available on the Community site at this section. There is also an option to subscribe to maintenance status updates at the Experian Data Quality status page.
-
Enabling workflow report to data consumer
Hi, I have a report created in a workflow. I have marked to expose it to data consumer roles. How to enable it so they can see it? I cant add it as a widget on a Dashboard page so far. Thank you
-
Best Practices for Transformations
Just wanted to see what the general approach is (best practice) for applying transformations in certain scenarios. For example, if several columns need to be transformed based on the value of 1 other column I see 2 approaches. In the Transform step perform If/Then/Else logic to apply changes only to specific values - this…
-
Suggestion: Auto-Save rules in a validation step
Hi, I have come across something rather infuriating this afternoon whilst creating a number of validation rules within the same rule group. Having spent the best part of 2 hours creating around 20 rules I briefly lost connection, after reconnecting I had to navigate back to the validate step. … all my rules were gone…. Can…
-
Group Data by Year
Hello, in one of my datasets I have a date column. Is there a way I can group this and count by Year only? I know I can group them by the whole date but is there a way to do it by year. Thanks!
-
Copy cells and Download data blocked
Hello, I am an admin at my company using Aprture Data studio. I created profiling on some tables, however when a data consumer opens such a profiled tabled when they right click on some calls, the copy cell button is greyed out for them, and the Download Data button says "Block by Administrator". Where can I enable that?…
-
"Create and Insert" selection is not visible in Workflow Export step
Hi, We have version 3.1.12 but "Create and Insert" selection is not visible in Workflow Export step. Is some configuration needed to get that functionality in use? Aperture Data Studio v3.1.9 — Experian Data Quality Community
-
Possibility to configure workflow report download destination?
Hi, Workflow report gives very good information about the details related to the workflow. Is it possible to configure workflow report to some common destination or use the URL of that report directly? It would be very valuable for the documentation purposes to get that kind of information automated.
-
Question on how to calculate a result
Hello, I am trying to calculate a solution using Aperture Data Studio. I have a table (as shown on the example screenshot below). For each ID I want to divide the values between levels to see if I get a an odd number. For example: For ID 1 : 1000:100 =10, 100:10 = 10, 10:5=2 Result = True For ID 2 : 18:5=3.6, 5:2=2,5…
-
Upgrading Experian Aperture Data Studio from v2 to v3
Hi, We are planning to upgrade our Experian Aperture Data Studio from v2.14.14.40 to the latest v3 and Find Duplicates Standalone from v3.11.2 to v3.14.5 We are already using cloud licensing and have also connectivity to the entitlement url https://entitlement.saas.edq.com/api/v1/EntitlementCheck. Could you please let me…
-
Pushdown Processing Advanced Function Mapping
Evening all, We're looking at implementing pushdown with Snowflake and have hit a couple of functions where we've had to workaround to avoid blocking the pushdown process. However, this advanced function mapping (as per documentation screenshot below) may help us fill some of those gaps and keep our workflows simpler. 3…
-
How to send a notification email to the assigned individuals for each issue in the issue list?"
Hello All, I need send a notification email to the assigned individuals for each issue in the issue list. Is that possible to achieve this within Experian itself. Can anyone explain me , how to do this? also please let me any specific access i need for this? currently i posses Designer role.
-
How to export dataset through API from Aperture Data studio?
Hello All I want to export one dataset in Experian through API and save it as csv file in my one drive. Dataset exists in space which created by me, let say space name is "To_Test". In this space i enabled the "Allow publishing OData" option. I generated the API key and tested the API in swagger UI and tested on "Retrive…
-
Automation - only writing to last batch to dataset
Hi, I have a multi-batch dataset (lets say DS1) that is configured for an external dropzone. When new data gets dropped and loaded into the dataset DS1 an automation then fires off a workflow. The workflow then gets that dataset DS1, and does some transformations, grabs metadata etc and then writes that dataset as a whole…
-
Power BI OData connections are significantly slowing down Aperture, how to configure to prevent?
Hi, Our self-service users are using Odata connections to fetch data from Aperture DS to Power BI but that seems to slow down Aperture a lot. During some report executions, it can even prevent logging into Aperture because the log-in window cannot be opened (without any error message). I can also see several Api Key…
-
External system drop zone stopped working
Hi, The drop zones that I have set up for several subfolders for many files has stopped working, and even after a restart continues to not work. The log contains a lot (a lot!) of these messages: INFO c.e.d.d.ExternalDirectoryWatcher [ExternalDirectoryWatcher-e3649cf8-de9f-42e2-8eec-edee6e98c157 1369857878] Error fetching…
-
Find Duplicates no connecting
Hi there, I am having problems making the duplicate stores connect to the server. I checked the server is running normally but when I am on the ads ui the connection is failing, can anyone help please?
-
Search and replace of multiple values.
Hi everyone!, I have a table with 2 columns, the first one is the string I should check inside a field, the other column is the value I should replace if its a match. How can I achieve this without creating a function with lots of steps for each string I need to search and replace. ORIGINAL STRING NEW STRINGTEXTO NUEVO -|…
-
Create a function that compares the date open to todays date
how would i create a function that compares the date open to today's date
-
Find Duplicates Issue
Hi there, I'm having this issue with the find duplicates step, can anyone help?
-
Schema-Flexible Configuration with JDBC (Apache Hive 6.0) External System
We've successfully configured an external system using Connection type: JDBC and DBMS: Apache Hive 6.0. I’m looking for guidance on how to set up a Schema-Flexible configuration. Specifically: Is it possible to use Schema-Flexible JDBC connections to support workflows that export data to multiple schemas? For example,…
-
Workflow option to Refresh Sources doesn't apply to Contains Match
Hi, I have a validation step that performs a 'Contains Match' on a lookup table (I am checking FK integrity). The workflow is set to 'Refresh Sources' however this does not apply to the lookup table. (I noticed due to failed rows). What is the recommended best practice here? Thanks
-
Date column recognized as "alphanumeric" while profiling
i have some date columns in my table (like below example). Just done profiling on those columns it recognizes their datatype as alphanumeric instead of date. after profiling i just right click and seen the values, there it shows as Date datatype all rows have date only in MM/DD/YY format because of this i am getting wrong…
-
Distinct count aggregation
I am not sure how to apply distinct count as aggregation while do group by ? There is check box "distinct", even though i enable that still does not give distinct count. Can someone help me to apply distinct count as aggregation in group by
-
How to explore Workflow script (preview) functionality
Recently we upgraded to experian 3.1, and i would like to try Workflow Scripting (preview). But i unable to find those feature. Can anyone please help me with this?
-
Dataset API - Dropzone
Hi, When using the dataset API, the value for "Enableddropzone" is FALSE even though the dataset is set up for "Enable external system dropzone". Does the API only show "Enable server dropzone"? Thanks
-
Re usable workflow, with different source
i have created the workflow(Let say workflow_1 with source as dataset_1) and make it as reusable. created another workflow(Let say wrokflow_2 as parent workflow) with workflow_1 as child workflow and changed the source as dataset_2. dataset_1 & dataset_2 are exactly same, the only difference is that the dataset_1 has one…
-
Salesforce import fails
Hi, This is one of the error messages. In some cases there is no error message in the log file although no rows have been imported. "Caused by: com.experian.aperturedatastudio.jdbc.sforce.phoenix.sql.ae: Socket Error: Read timed out Caused by: java.net.SocketTimeoutException: Read timed out" Do you know what can cause…
-
connect to Snowflake external system with OAuth 2.0 authentication method
Hello, How can we connect to Snowflake external system with OAuth 2.0 authentication method? Thank you
-
Strengthening Data Quality with ABN Validation
Hi DQ Community, I wanted to share some insights into the powerful custom workflow step for ABN (Australian Business Number Validation) within Experian’s Aperture Data Studio. Built using our SDK, this workflow step enables users to validate ABNs with a real-time API lookup against the ABR database. It not only confirms…
-
List Automations?
Hi - is there a way to list all automations? (i.e via SWAGGER). I see there is a way to see schedules, but an automations listing would be helpful. Thanks
-
Best approach- to do profiling for large dataset (20 million records)
Hello , I need to do profiling for tables which have more than 20million records and also the table will get update with new records as every week. 1) Is that right to do profiling for such a large dataset, will i get any performance issue? 2) as the table gets updated with new record as weekly basis, is that possible that…
-
QAS Vs Experian Aperture Address Validation
Hi, We currently use QAS for address validation and currently running POC for Aperture data Studio. Please can you share the benefits of using QAS over Aperture for address validation. Is there any difference in the way address is validated in QAS and Aperture. Thanks, Jencil
-
I just got a 3+ sign-ins in a month badge or a frequent flyer badge.
I see dont see any info about this or any other badges, or way to earn points.
-
Validate Datetime Datatype
i want to validate that the column datatype is "Datetime" Datatype. i found only "Is Date" function, but i want to ensure that column is Datetime by adding rule in validate step of workflow. Is there any function or work around to achieve this? Thanks
-
Moved: Gen AI in Aperture Data Studio
This discussion has been moved.
-
New Database Drivers
Are there any database drivers that people would like us to have access to? Please cast your vote below, or comment which driver you would like to see.
-
Missing Tables in "Table or Database View" but Accessible via "Database Query
Hi community, I successfully created an external system connection to a database schema, including credentials. However, when I try to create a dataset using the "Table or Database View" option, I notice that some tables are missing from the list. Interestingly, I am able to access and query those missing tables using…
-
Changing the External Source underlying the data set
Hi, We have developed several workflows using several data sets that are sourced from a particular External Data Source. Now the external data source is moved and renamed. Is there a way to point the Datasets to the new External source ? Many Thanks. Regards, Manoj Bhosle
-
How to save profiling result as view for multiple table(50+ tables)
I have many tables, i need to run profiling on each of the tables and need to save the results as view. Since i have more number of tables, is there any way to do this altogether, rather then doing the same thing each table one by one.
-
How to Cancel an Ongoing Dataset Refresh?
Hi, We successfully triggered a data refresh on our dataset. However, we now need to stop or cancel the refresh in progress, but we’re unable to locate an option to do so. Could someone please guide us on how to cancel an ongoing refresh? Thanks in advance for your help!
-
Route to live process & environments
Hi, I want to get a route to live process in place whereby only things which have been peer reviewed and signed off are promoted to live, and any other work just stays in the test environment. We already have 2 environments set up (default and test). The test environment isn't really used, so would be an ideal blank canvas…
-
OData $top in Power BI
Hi, We are trying to pull a dataset into Power BI and limit to 1000 rows whilst we iterate to make refreshing snappier. However, we're getting an Error 400 that $top isn't supported, though the documentation seems to suggest otherwise. Should this work? It feels like the way Power BI structures the query, perhaps its the…
-
Address Validation Issue
Hey community, I have just updated to the new version of ADS, also updated the address validation, copy all the right files to the right folders but there is still an error on the Address Validation. Can anyone help with this?
-
Guidance Needed: Transitioning Data Sources from HD Insights to Databricks
Hi Team, We are anticipating changes in our datastore architecture, which will significantly impact datasets and views currently sourced from HD Insights. These sources will need to be repointed to Databricks as part of the transition. Could you please advise on the possible solutions or best practices for handling this…
-
OpenText Content server export
Hi All, I’d like to ask whether Aperture is capable of directly connecting to OpenText Content Server, without requiring any middleware or intermediate systems (such as Talend or external scripts). Is there a native connector or export integration available for pushing data directly from Aperture into Content Server?…
-
How to modify in aperture the header for Powercurve Collections interfaces
I am working on the input interfaces that PCC manages, which has the following nomenclature ProcessingDate|Row-count Here is an example: 20250603|5762202 1416|81178235||Vendor|| 6700|81380685||Sold-From Party|| but I can't get the columns to join correctly. as a result I have this 20250603|5762202||||||…
-
Fire event - if input has no rows
Hi All, I would like to fire an event (run a specific workflow) if NO rows in the input - but there is only an option to fire events if input has rows: Basically the goal is to only send correct data to an external system (Snowflake) if there are no errors (at all) in a dataset. Is there a way to set this? Many thanks!…
-
Column header in the second row
Hi All, is there a way to use the second row (instead of the first) as the column names when uploading dataset? Or is there a workaround? There is a dataset that we would like to drop into the DropZone but the header is always in the second row… Many thanks! Vera
-
Is there an easy way to do this partitioning?
Hi, I have seen previous posts on partitioning, and use that technique regularly. However, my need this time is slightly different. I have groupings of duplicates, but I would like to count incrementally when I come across a new identifier. I actually have this working now, but it took some Aperture kung-fu, so wondering…
-
fill down or propagate values to empty cells
Good morning, what's the best way to fill down or propagate values for fields like 'Year' and 'Submission Month Name' so that all rows in a dataset display these values consistently? Many thanks in advance
-
Our Data Management User Group is on 20 May 2025
Once again we would love you to join us for our next Data Management User Group taking place on 20 May 2025 between 10:00am – 4:00pm at our offices in Cardinal Place, Victoria, London. This will be a special User Group event as we have an opportunity to share a real milestone in our product innovation. Our ‘new generation’…
-
Sorting is better to do before Join?
Does sorting of the participating ids in the joining condition helps in better performance? i thought if I use a sort step before Join that will improve my performance but it is actually taking 15+seconds extra when I am using sort step before join, is there any other way to improve the performance time or it is not…
-
character encoding mismatches
Hi, I'm having an issue when downloading a dataset in CSV format, some of the characters are been introduced on the download such as ’s instead of " ' ". Is there a setting or function to prevent this issue? Best regards, Marco
-
Spaces for sharing
We're experiencing a problem when trying to share Views. Specifically, when selecting Spaces for sharing, we receive the following error message: Has anyone else come across this? Any insights on what might be causing it or how to resolve it?
-
Repository backup - Linux
Hi there, I found on the documentation that is possible to have a repository back up setup on the windows installation but we are using a linux deployment, is it possible to do this if we are not using windows? TIA
-
Exporting - Extension Missing?
Hi, just upgraded to version 2.14.12.195 and noticed something in the 'Export' step. If I export to CSV, Excel etc. and my file name is split with a full stop, the extension is suppressed. For example file name "FILEOUTPUT" gives me" FILEOUTPUT.XLSX" but "FILE.OUTPUT" does not add the .XLSX extension. I noticed because…
-
Export issue - values not appearing
Hi All, I’m wondering if this might be a known issue: I have a workflow using a re-usable workflow that includes a lookup to check whether certain records exist—so the result should be either true or false. When I run the workflow manually, the true/false values appear correctly in the exported file. However, when the…
-
🎉 Aperture Data Studio Version 3.0 - Almost here
Aperture Data Studio v3.0 is almost here and we're very excited to share this update with you. Full release notes will be added once the download is available. First to note: v3.0 is like any other quarterly release but you will have to have moved to cloud licensing. If you upgrade without a cloud license token applied (or…
-
UK Postcode check
Hi, I have a requirement where I receive a csv file with postcode(no other address fields is provided), and I need to do the below 1. Mention if the postcode is Valid and compliant as per Address GBR data 2. Standardize raw postcode value to UK postcode format 3. Specify the reason for UK postcode being…
-
Unable to access Session API
I am not able to access the Session API from Swagger, it showing me 401 as response code. We have Aperture as external system we are not able to fetch the records from Session but able to get the other metadata information. I checked in Progress data direct response code for Session are 401 there as well and even in…
-
Aperture link to Googlesheet thru BigQuery
I am in Aperture Version 2.8.8.27 I am trying to get connected to Googlesheet thru BigQuery. BigQuery is set up with link to Googlesheet and connection to BigQuery from Aperture seems to work ok. External system Connection is OK, using Service Account with .jason Private Key File. But when I try to add dataset in aperture…
-
Pass step data to Fire event?
Hi, I thought I had this set up correctly, but testing reveals otherwise. I have a reusable workflow that is set up to send data passed to it to an external destination (as an Excel file). However, I only want to run this when the data being fed has rows. The reusable workflow is fine when used in a workflow - it uses the…
-
Rulesets and Rule Name
Hi, I want to explore using Rulesets, but the naming of rules is stumping me. I want my rule name to be the mapped column I am using, followed by a short description. Column=V_ID and description=not null. The rule name created though is "V_ID-Input - not null" - it is pulling in the input column from the ruleset definition…
-
What's the syntax for the Dataset "file pattern" text when loading from an SFTP dropzone?
I'm setting up a Dataset that automatically refreshes with data from files dropped into an External System dropzone (SFTP in this case). I only want to load specific files, determined by the file name. To do this, I was going to use the "Starts with file pattern" config option, but I couldn't find any information about the…
-
Trend NOT showing with Date as X axis
I am getting trend when using a different column in X axis than Date But when I am using Date the trend is not coming its BLANK. I have date as the Batchtime metadata, and I am trying to use the trend on below data I have done trend many time earlier where I had seen trend was coming good even if I have the date in x axis…
-
Set Space & Dashboard as a default?
Is it possible or has it been discussed about having the option to specify a Space and Dashboard as a default at log-in?
-
Interactivity not Working
Hi, I have the data interactivity available till this point in my workflow where I am doing multiple grouping and then brought them in one place by union Here is the Workflow screen shot, where till 1 (marked in the SS) I am interactivity . Output of transform step shown above. And now this I am trying to take in…
-
Multiple column return in Lookup
Is there a way to return multiple columns from the lookup table in return I have DS1 and looking up DS 2 and want to return 3 columns from DS2. My final output will be all col from DS1 and 3 cols from DS2. Trying with Lookup type "All Value" but in this option just getting 1 column in return
-
Lookup or Joiner using Contains in the Match
Is it possible to do below check I have this in one channel Want to check and populate 'Issue Pending' column value from other channel where it has comma separated values
-
Updating Issue List Fails
Hi, I am trying to update an Issue List (approx 50,000 rows that need updating). I try and run a workflow to do this but it fails with the message below. I go to rerun the workflow and it runs for a while but then ends again. Each rerun only lasts about half the time as the previous one. I don't have access to the logs for…
-
Case statements in Aperture Data Studio V2
Hi everyone, I’m looking to convert a SQL query in Aperture, which contains multiple CASE statements for a single column in the dataset. I’m looking for the best practices to achieve this efficiently and clearly. The column I’m working with contains various conditions that need to be evaluated. Could anyone share their…
-
Kill Dataset refresh job via API
hi, I am performing bulk data profiling on datasets using API automation where my steps are as below list all datasets to be data profiled in a csv file process csv for each row trigger dataset refresh and capture job id wait for job to get completed or for max 30 mins. if time elapsed is more than 30 mins then skip next…
-
Updating Data via Aperture vs SQL
Hi, Was hoping fellow-customers or Experian staff would be able to give their experiences with this one. Wanting to update data in the DB directly using Aperture (thru the Export step - JDBC), but the DBA wants updates done via SQL scripting (is hesitant to use Aperture). I am pushing for Aperture as it is a controlled,…
-
Delimited csv file creation using Export step
Hi, We are using Experian Aperture Data Studio version 2.14.14.40 and have changed the settings to accept csv delimiter to pipe (|) But there is a requirement to delimit csv files based on runtime configurations. Is there a way to define the delimiter in the export step while writing datasets as csv likely from a parameter?
-
Exporting to External System using JDBC
Waiting to get an external system set up to allow updates via JDBC - in the meantime, if I select mode = UPDATE in the export step, does a full SQL statement get generated (to allow our DBAs to verify and QA the process). Thanks
-
Issue list best practices
Hi, I am starting a data migration/cleansing project and as each entity is analyzed and validated with data quality rules, any failing rows are sent to an issue list. That issue list is then shared with business leads to determine best approaches to fixing the data. There will be approx. 70 entities that we will working…
-
Native Function: Is Web URL
Hi, I am using the above function and the result for checking this site "www.californianotary.academy" comes back as bad, even though it can be accessed in a browser. Does that function expect something like ".com" rather than ".academy"?
-
Update Issues once Resolved?
Hi, is it possible to update an issue once it has moved to 'Resolved'? For example, a set of data gets manually updated, and after resolution we want to reflect that via the 'External ID' (e.g. a ticket number). Thanks
-
Automated date in output
I wonder if there is any way of setting up in an automation the Take Snapshot step with the date information on it. Like for example: ADSExtrac_20241113.csv
-
Is it Possible Integration with with NETCONF Protocol ?
Can Aperture Data Studio integrate with device configuration system with NETCONF Protocol
-
Sorting an Issue list results in fewer rows
hi, So I have a workflow that I use an 'Issue list' as my source - the issue list has 29 rows. If I add a step to sort on the 'Failed Rows' column, my output for that is now 22 rows. No other filtering going on. Tried it on 2 different issues with the same result. However, if I remove the sort on the 'Failed Rows' column I…
-
Best approach for this set-up?
Hi, Any recommendations for this configuration? Lets say I have a space called 'PROD-DQR' that is used to access production data with a read-only credential to the source DB. It validates data, sends to issues etc. Only DBAs are allowed to perform updates in production, so was thinking: New spaced called 'PROD-UPDATE' that…
-
Sneak peak of new data quality offering: Let us know what you think
Hi everyone, In this post I'd like to provide you all with a sneak peak of a new real-time data quality enforcement offering that we're currently exploring, that we'd love to get your feedback on (complementing our existing contact data validation products). The idea centres around exposing Data Studio functionality (e.g.…
-
Dynamic Reports in workflow - if x then do, if y then do something else
Hi all I'm new to Aperture and have just built a report in a workflow. It looks good and I am happy with the tables that I have pulled through. My report shows a summary of all of the checks and then I have an individual table showing the failing rows for each of the rules. Of course, sometimes, I have a rule that doesn't…
-
Annotate Columns
Hi, is there a quick/easy way to mass update when performing 'Annotate columns'? I want to add tags not based on the data contents, but on security definitions. E.g. Some columns could be PUBLIC, some could be CONFIDENTIAL. Thanks
-
Experian Aperture Data Studio Report View
Hello. new to the tools trying to figure things out. Making progress, I've created several workflows successfully, and created datasets using snapshot, and used those datasets in other workflows and views. My question concerns Report View In Workflows. I've found very little documentation on this. I added a Report to the…
-
Data Studio certified to run on Azure Stack HCL or Nutanix?
Is Experian Data Studio application certified to run on Azure Stack HCI (Azure's version of VMware) and/or Nutanix?
-
Unable to connect Find dupliactes on new server
Hi team, We have recently installed the aperture Data studio application recently on our new pre-production server and we are unable to connect find duplicate server due to the below error. Please help us to this issue 2024-11-04 00:05:32 205 WARN c.e.d.m.MatchServiceManager [MatchLicenseMonitor] Unable to connect to Find…
-
Do you have a need for Pivot/Unpivot steps?
As part of our product discovery activities, we would like to find out if any of our clients have a use case for pivoting or unpivoting data. If you do, we'd like to hear about it. Please leave us a message and we'll get in touch.
-
Fuzzy Matching Logic
Hi, I have a requirement to match records from two separate systems on the basis of FirstName, LastName and DOB from System1 and FisrtName, MiddleName, LastName and DOB from System2 to return the match Id from System2 to System1. Below are the challenges The names are not consistent in both systems . For eg in system1 for…
-
Validate address data dictionary?
Hi, started looking at 'Validate Address' step and cannot find a data dictionary for the returned fields. For example, AddressAction I see 0 & 3 and Street Non-trivially Corrected I see blanks, 0, 1. Any pointers would be great, thanks
-
Any Function to check the one field in Present in the List of the fields?
For example I have a column where I have Value like this If I use function contains then I am getting this true for all of the above scenario, but I want only row 1 should be true and rest should be false when the entire string is not matching. Can this be done?
-
Turn a field storing a list into rows?
Hi, is it possible to turn a list stored in a column into rows? For example: ID COL 1 AA,BB,CC 2 XX,YY,ZZ Becomes 1 AA 1 BB 1 CC 2 XX 2 YY 2 ZZ Thanks
-
Unable to restart the Aperture services
Hi team, Suddenly the aperture data studio application is connecting. We tried to restart the services and the services are still stopping .we are unable to restart the services. Can you please help us to resolve this issue ASAP .
-
Dropzone
Hi there, How do add columns on a dropzone file? The columns have been added in the source file but it's not reflecting on the dropzone file in aperture. How do I fix this? I have tried adding a new external system but it doesn't work. Many thanks, Mariana
-
Network error
I am trying to create a development environment to test some changes but when I try to import anything to it, gives me this network error message. Any ideas on what the problem is? I am connected with the VPN, already checked that! TIA, Mariana
-
Best practice for checking that Datasets have been refreshed
A user asked this question: We have hundreds of datasets we need to refresh before a migration, what is the best practice in ADS to make sure they have all been updated, without adding a source in a workflow for every dataset can you iterate through the desired datasets and look at the metadata to determine when it was…
-
Inquiry Regarding Royal Mail Address Database Updates
Good afternoon, We are currently using the "Validate Addresses" step to check UPRNs. However, we have observed a significant number of addresses—where we already know the UPRN—that are returning empty during validation. Could you please confirm how frequently the Royal Mail address database is refreshed? Thank you for your…
-
find duplicate update row limitation
Is currently is there any limitation in the latest version ? I am getting error in my existing workflow . Please suggest where I need to change to set the limit
-
DDL for datasets before including in aperture.
Hi, Is it possible to see DDL of tables before adding those in datasets from external system? or Aperture does not have that kind of control. can i see DDL of tables before adding? or service_account wont have that control.? Br, HS @Ian Hayden , @Henry Simms
