-
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 names, E.g. Input: Header1,Header2,Header3,Header4 ---------------------------- Headers 1,2,3,4 ----------------------------- Data 1,2,3,4 ----------------------------- Data Output Header1,Header2,Header3,Header4ā¦
-
My data consumers are unable to download as CSV.
Within Role Permissions the Data Consumer Role is a tick next to 'Download data' and 'View Datasets' However when the Data consume access a report via a dashboard the 'Download as CSV' button is not there. The data consumer profile has 'Admin' privileges in the space that has the workflow with the Report step Thank you inā¦
-
Configuration of a dropzone
Hi, We are working on the plan for integrating an application and Aperture. The latest was that a dropzone was going to be set up where we could store all the relevant files, which Aperture could then pick up. However, we have some questions around Aperture dropzones . Given the sensitive nature of this data, we need toā¦
-
Address Validate with Business Data
Hi When comparing QAS Batch with Aperture Validate Addresses to enhance data, I notice that Aperture is returning far fewer business names and phone numbers than Batch, the address matching and enhancements are similar. In batch I reference āUK with Businessā as an additional dataset, in Aperture I am selecting GBRā¦
-
Renaming the Datasets and share to other Spaces together
Is there a quick way to rename all the datasets together. Example wants to add some prefix to all datasets. Can we use API to do the same? Is it possible? Is there a way to share multiple views at the same time. I see we can select multiple views from One Space and click on Sharing but when I am going to the next Spaceā¦
-
Experian Data Studio Job Stuck.
Hi, One of the experian data studio job is stuck for 23h on our dev server, we have tried to cancel it but it won't stop. Is there another way to stop the job without restarting the service, as we don't want to interrupt other jobs and schedules running in parallel on the Monday morning. if there is a way to kill the longā¦
-
Functions
Hi, I'm working with Functions. Re:product development, it would be a really useful to be able to multi-select Functions, eg when applying Sharing, Deleting etc, rather than having to do each one individually. Thanks (in hope and anticipation) Nige
-
Aperture data studio log file location
Hi, I have noticed something now in our prod servers. The log file generated for aperture data studio is still being created in the old location along with archived log folders, where as the repository resides in the new location. repository is here right now: D:\ApertureDataStudio\data\repository and the log file is stillā¦
-
Importing data form a cloud-based MDM solution
Hi, We need to import data into Aperture Data Studio from Boomiās Master Data Hub module. As a cloud-based MDM solution, Boomi does not allow direct access to their databases. Therefore, we would ideally want to develop an integration using web services in one of two ways: Aperture is configured to import data via Boomiāsā¦
-
Is there an function to identify extra spaces between words?
Hi, I would like to check if is there any out of box solution for identification of extra spaces between words. Thanks
-
What is your policy on the use of apostrophe and hyphen in email address?
-
How to convert a value using if-then-else?
Hi, I've created the following function to convert an input to zero if the input equals to null and to return the value if it is not null. However, the if-then-else step states that function must return True or False which is not the output required. Could you please have look into it and advise the way forward. Manyā¦
-
SAP Views as Datasets
Has anyone used SAP views as a datasets? I have a strange situation where SAP View can be defined thru SQL (select * from sap_view)Ā but I cannot define the view as a dataset directly. The view is not visible to pick from. Did anyone face this issue? Is there a solution?
-
How to export line breaks?
Dear All! In the workflow I'm running I have loaded a dataset (from excel) containing line breaks. During the worklow I'm transforming the data, but when exporting in .xlsx I'm receiving "\n" instead of the line breaks. Is there a way to have line breaks in the export file instead of "\n"? Many thanks for your help!
-
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:\Program Files\Experian\Aperture Data Studio 2.7.3 It is 35 GB. I believe it is junk and is a result of an error. @Henry Simms please comment . would it be OK to delete it or would it affect my server installation in anyway. Iā¦
-
2 questions on TRANSFORM
Looking for ideas from community. 1) Transform ā āEqualsā Command I am in a workflow to check if the input file matches to data loaded in SAP Table. There are about 70 columns and I want to create new 70 check columns as follows: field1_input equals field1_Sap field2_input equals field2_Sap ... ā¦. field70_input equalsā¦
-
Filtering within a validation rule
Hi, I have the following scenario for a validation rule and I'm struggling with the logic. Column A has X, Y, Z as values and column C has 1,2, 3 as values. So, my validation rule is "IS NULL" against column A, however I want it to return only when column C is equal to "2". Also, I need to build the above rule within aā¦
-
Workflow not completed - notification
Hi All! Is there a way to set an (e-mail) notification in case a workflow has been stuck? Meaning it has not been completed after a certain period of time. I know we have a notification for failed workflows, but can not find anything for scenario "started, but not completed." Thanks!
-
Schedule for every 2nd week
Hi All! I've set a schedule for a workflow with the following criteria: Recurrence pattern: weekly Every 2 weeks on Monday. Although it is still running every week. Could you please let me know if this is a known bug and if it has been fixed in any of the new versions? Many thanks!
-
Notifications based on emails in the data
We have 50 service desks placing orders for customers around the country. We want to monitor those orders for data quality errors and notify the desk leaders of any fails which occur on an hourly basis during the working day. Currently each notification email address has to be typed in manually, so even though the deskā¦
-
Equals (Strict) function
Is there any documentation on the functions? I am looking for explanation for Equals (Strict) Function. I have a strange result. The function seems to work randomly. Here is an example: ADDR1 STREET ADDR1_Chk 401 UDAYBHANU APTS, 401 UDAYBHANU APTS, false 222 GETTY AVE 222 GETTY AVE true When I check the data in Excel,ā¦
-
How to determine Nth occurence in a column?
Hello. Do you know of any function or combination of functions that can achieve a new column in the data as the "occurrence" column in the screenshot below? I would like to know if the ID in the first column is the 1st, 2nd ... Nth occurrence in that column. Is there a way to achieve this? Thanks in advance. Richard
-
Anyone using SAP Tables with LRAW type columns (Example: STXL)
We need to bring in SAP STXL table to Aperture. This has an LRAW type column named 'Data'. This is not readable in SAP front-end also. Currently we need to bring it in the table to Oracle Database thru custom scripts in SLT Replication and then bring from Oracle Database to Aperture. Has anyone found a way to bring thisā¦
-
What are the limits of data loading in Data Studio?
Back in June, I read an internal post by @Henry Simms that suggested that in test we had loaded 162 billion values into Data Studio setting a new record for the largest single table loaded in to Data Studio, using v1.4.0. This test was done following a request for performance info for a very large and very wide file, weā¦
-
NI No Validation
Hi, Can somebody please advise on the algorithm used in the NI No (UK) validation step. I am finding some numbers which match the validity rules described here National Insurance number - Wikipedia are being rejected by Experian Aperture I'll try a trim on the field (in case that makes a difference) and if anybody wants toā¦
-
What "4016: Functions exception occurred" means?
Hi, I'm creating a workflow with a large set of validation rules (110 rules and 74 groups) and when trying to see the results I'm getting the "4016: Functions exception occurred". I've tried to find the answer in the documentation but no lucky. Could you please let me know if I'm missing something. Thanks
-
Documenting Aperture Data Products with Metadata
In complex Aperture environments, like in any data environment, you need to understand what data you have, where it comes from, what has been done to, where it has been delivered. These details can be found with with functions like metadata management, data lineage and so on. In Aperture, there exists a lot of featuresā¦
-
Creating charts from workflow
I've added a chart step to one workflow but when running it I cannot see the chart under the chart list, is that correct or am I missing something?
-
Oracle Java SE
Hi, Does Aperture data studio and Find Duplicates installers has embedded java installer that updates the following java at the path: C:\Program Files (x86)\Common Files\Oracle\Java\javapath_target_183572265? @Henry Simms @Sueann See Br, HS
-
How to do pivot Column to rows
I have rule1, rule2, rule3 in the column names and corresponding count in the rows, now I want to get the result as Column Names : Rule, count How I can achieve this?
-
Harmonize Duplicates - Select best record based on score with multiple criteria
A customer posted this question to me: "I want to pick a survivor using multiple score based criteria in the Harmonize step.Ā So when all records in a cluster have the same survivor code ( a number I create) I need it then to pick the record with the newest date. For example two records in a cluster might have survivorā¦
-
Format number to 2 DPs
I have some data that I'm importing and I want to convert to currency format nnn.nn - there doesn't appear to be a way to do this in aperture. Any ideas? I've tried the Round function but no joy - I want to convert 28 to 28.00 etc.
-
Spelling Check
I've quite a few datasets that have spelling problems or words with number instead of a letter and vice versa i.e. Flat I (1 is replaced by an "l" ) or FIeming ( "l" is replaced by a capital "i") . What is your advise to handle this issue?
-
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 a specific column. Any suggestions?
-
Not been able to drill down from a view created from profile data step
I've created an interactive view from the profile data step however, after publishing the view I'm not able to drill down to the actual data. Is that the correct behaviour?
-
Group step in Workflow throws java.lang.IllegalArgumentException: Invalid handle
Hello there, I have a workflow in Experian's Aperture Data Studio (version 2.5.11.115) which unions 24 inputs From this union, I then have a group step which allows me to see what the validation results are for each category When I use aggregates, there is no problem but when I group and aggregate together, I get thisā¦
-
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 system settings. Will it notify me the diskspace of the experian match store drive or the installation drive. Second question that I have is in case of an abrupt stop or restart of my experian data studio and find duplicatesā¦
-
Find Duplicates Blocking Keys and Rules in v2
If you have the license for Find Duplicates Fuzzy matching then you could use this functionality to match records based on fuzzy matches. This needs blocking keys and Find Duplicates rules I noticed that in V2 that the Blocking Keys and Rules are now combined and accessible through Step Settings however I also noticed thatā¦
-
Setup Secure SSL using self-signed certificates
Is anyone able to provide some clear instructions on how to generate and install a self signed certificate with Aperture? I have tried to do it myself but Aperture is still throwing the following error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certificationā¦
-
APIs to get the details regarding Data set and wf schedules
How do I get Information about all the datasets refresh which have been scheduled and timing of those (whole system including all the environments and spaces)? I was trying the below API What is execution ID? Also Daily Information about scheduled runs of the datasets refreshes including the information about how long theā¦
-
I want a column to only accept 'A, 'B', 'C' or 'D' as the correct values.
I want to restrict the values for a certain column. It should only accept either 'A, 'B', 'C' or 'D' as the correct values.Ā If I see any other letters it should not pass the validation. What is the most efficient way to do it?
-
How to check if an input value contains numbers
In Aperture Data Studio, in order to check if an input value contains numbers, you can use the Matches Expression function. The Matches Expression function uses a regular expression to specify a pattern to be matched against. If you are not familiar with a regular expression, it may take some exploration to get to theā¦
-
How to validate US dates stored as YYYY-MM-DD
I have several fields that have dates stored in the format above. If I run the built in function "Is Date", the dates all fail. Is there a date system setting I need to change, or create my own function? What date format does the "Is Date" function require?
-
Find Duplicate - Based on different criteria
Hello, Requirement is find the duplicates based on 3 different criteria - Name and Phone Match Name and Email Match Name , Address Match Now how to achieve this, should I use 3 Different Find Duplicates in Parallel and then check Match Status any 1 of them 0? Is it possible to check in one Find Duplicate? I think we canā¦
-
Even after license renewal, self service portal shows 0 credits for service calls.
Even after license renewal, self service portal shows 0 credits for service calls. How can we resolve this soon? Whom should we contact?
-
Aperture API to get the health of the system CPU Usage
Can we get the health of the environment through API? What is TenancyID? how can we get the CPU usuage and other details of the enviornment. If we get the response in JSON from API we can Consume the JSON in Aperture and Publish it in a Report or Table but how we can automate those? from consuming JSON to Publish in theā¦
-
Find Duplicates - Address Element Mapping
Hi I am trying to find duplicates in data from multiple countries. I'm mapping company name to "Company Name" type and Postcode to "Postal Code", but all the other address elements are mapped to "Address" type rather than specific elements. Would this impact the matching as Find Duplicates is failing to cluster veryā¦
-
Setting up a parameter to work across multiple workflows
Hi, I have a workflow parameter that feeds into both a column and and export. The problem I have is that the export is on a secondary workflow that is triggered by a fire event if it has rows. I have tried to add the parameter to the custom event and added the workflow parameter to both workflows, however I am strugglingā¦
-
Issue with Views when upgrading to v2.6.3, v2.6.4 and v2.6.5
We are aware of an issue that affects some installations of Aperture Data Studio versions 2.6.3, 2.6.4, and 2.6.5. If you have upgraded to any of these versions, please contact us https://docs.experianaperture.io/more/contact-support/ so that we can investigate whether your installation has been affected by this issue. Weā¦
-
Force workflow failure due to failing rows
Is there a way I can force a whole workflow to fail as a result of failing rows in a validation step(at desired tolerance level)? I want my workflow to stop and fail when I have a certain number of failing rows. I have email notifications set up with fire event to email me when I have failing rows but I also want the fullā¦
-
Performance decrease since upgrade to version 2.6
I have experienced significant performance decrease since I upgraded Aperture from 2.4.9 to 2.6.0. The average execution time of my main workflow moved from around 1 minute to 2 minutes. Thanks to the new execution log diagram I realized that the bottle neck is the execution of a couple of embedded workflows that areā¦
-
Enabling LDAP
In case you haven't noticed, LDAP has been introduced since Aperture Data Studio v2.0.11. Go to Settings>Security to set up the LDAP properties. Once this is set up, you can test the connection to the ldap server. A message will be shown to indicate whether the connection is successful or has failed. Once the connectionā¦
-
How do I determine which version of Aperture I am running please
Looking at the Downloads and Release Notes for 2.6.2 I cannot see any link to the download. There is another document that says it was updated on 18 Jan and includes download links - but that seems to be installing 2.6.2. How does one tell what version one is using and, if the 18 Jan link is not for 2.6.2, how does oneā¦
-
Issue with dates being read as American dates
I am pulling in my source data with a column that contains dates of the format dd/mm/yyyy. When annotating the columns, I have specified the column to be a date column. Now ready to explore my data, most of the dates in the column have correctly loaded in format dd/mm/yyyy. However some have converted to format dd-MMM-yyyyā¦
-
Critical vulnerability in Apache Log4j library
On 9th December 2021, Proof-of-Concept exploits for a new critical zero-day vulnerability affecting Apache Log4j, version 2.0 to 2.14.1, which results in remote code execution (RCE) were made publicly available. This is being tracked as CVE-2021-44228. Experian is fully aware of the log4j security vulnerability. Experianā¦
-
What is the history of Aperture?
From a background perspective, what is the technical history of the product? Meaning was it built by Experian from the ground up, was it an acquisition that was rebranded, etc.? Not an urgent request, but I like to understand the genealogy of products. Many thanks!
-
Is anyone doing Change Data Discovery in Aperture?
In Pandora, detecting changes in different versions of source data was relatively simple - one added some sort of hash to a record, saved the result as a table and then compared the two versions. But I cannot see a straightforward way to do something similar in Aperture. Also, is it possible to use e.g. Oracle data logs toā¦
-
Importing DataSets - Filtering Data
Hi, I was wondering if there is currently anyway of limiting/filtering out data from an underlying table before importing it as a dataset? I have a number of transactional tables that I want to bring in to Aperture, however it would be great if I could limit the date range of the transactions before importing the tableā¦
-
Installation of Find Duplicate Different Instance
Can you please help me with the instruction link for installing Find Duplicate Workbench a separate instance (Aperture Data Studio v2)
-
Aperture compatibility with .NET 4.8
Hello support team, I hope you're fine. We need to do an upgrade to .NET 4.8 According to this article : https://docs.experianaperture.io/more/tls/ssl-certificates/electronic-updates/ "Where appropriate,Ā we strongly recommend .NET 4.6Ā orĀ Java 8. For integrations using OpenSSL" Is it possible to do such upgrade ? FYI: we'reā¦
-
Is anyone connecting Aperture to an Oracle 10G database please
I am looking to connect Aperture to a number of Oracle 10G databases and a number of rather old SQL Server databases. Has anyone tried this, either with the Experian JDBC drivers or with 3rd Party ones please?
-
Filtering Data on load
Is there a feature in Data Studio to filter data from an external system load - i.e. Select X from Y where Z instead of loading complete tables or does that have to be built from views? I'm on v2.4.9
-
š½ šŗ Achieve more with your data - videos
On the Data Studio homepage there is a widget named 'Achieve more with your data' that gives access to some short (5-7 min) videos showing how to complete useful actions within the product. In case you cannot access these videos within the product they are listed below: Video #1 ā Profiling in Data Studioā¦
-
Drop zone configuration in server.properties
Hi Team, Can we configure customize datadropzone folder at different shared location same as export directory by editingĀ server.propertiesĀ file? Thank you kin advance Best regards
-
Finding database / table attributes
Hi, Is there a way of creating an output of all the fields and attributes of a table / database. I thought there was an option when you add a dataset so that you can see all fields, field types, field lengths etc but all I can find is an option to have column headings only. Or is there a function that will provide theseā¦
-
finding previous day record
Hi, I have a file of daily transactions where I find details of the latest record using Max date. How can I find details of the previous days' transaction in order to compare it to the latest day? I need to find out when a particular value for an account has changed from one day to the next - sometimes it doesn't changeā¦
-
Calculating the difference between values on separate days
Hi, I have created a grouped output which counts the number of loans per day as below. How do I calculate the difference between the number of loans each day? i.e. the difference between 16th and 17th Aug would be 35 .. and so on for each subsequent day? I canāt find any examples or functions that do this.
-
Connecting to D365 with OAuth
Can someone tell me what the settings are for the below when accessing D365 Authentication parameters (OAuth) Client ID - The client id for your application. Client Secret - The client secret for your application. Access Token - the value of the access token obtained from external sources. Refresh Token - the value of theā¦
-
Migrating Aperture Studio from one VM to another
Hi, We are trying to migrate Aperture studio installation from 1 virtual machine to another. Could someone please guide through the steps to follow. We tried copying the repository from old to new - but that is not working. The services fail to start properly. Many Thanks.
-
How to promote from dev to prod environments when using different external systems
Problem: Iāve recently been working with a client who had used their Data Studio development environment to create workflows based on data theyād extracted from their development SQL Server database. They were in a position to promote those workflows to their production environment, and also point the data sources to useā¦
-
We need your feedback on Find Duplicates
Hi all, We are evaluating the paths to a better Find Duplicates rule building experience. We understand that there are many different perspectives on this topic, but ultimately, we really want to build something with the customer's journey in mind. We think customers would appreciate the improvements specifically in theā¦
-
Replacing the string value with Null if the end of the string matches with the LOV
I have company names in a field I want to replace the end of the company name with Null if the name is ending with OY, OYJ, RY etc. For example if I have company name as Mahu COMPANY OY I want to replace it as Mahu Company I have a long list so I have kept that in a lookup table now which function should I use to achieveā¦
-
New Experian Data Quality Roadmap
I am delighted to announce that theĀ interactive version of Experian Data Quality's product roadmapĀ is now available on the User Documentation website, which is publicly available. Weāve collaborated with our customers to gain a deeper understanding of the information youād like to access related to the product roadmap. Asā¦
-
REST API: get dataset list and their information
Hello, We are looking to identify all datasets (of all spaces) that are in autorefresh. When we use the REST API: datasets and getApiKeyInfo, we get datasets lists with many information but we don't have : Attached is an example of getApiKeyInfo api response regarding the table AUSP Is there any REST API which allows toā¦
-
Does Aperture have "rank()" function and how it works?
Hi, is there similar function for Aperture? For example case
-
Manual review of Find duplicates clusters
Using a similar approach to that covered in an earlier post we demonstrate a method for manually reviewing clusters to split one into two or more, or join two or more together. In this example we will use the standard sample Find duplicates test file with UK addresses. Problem overview Using the standard GBR Individualā¦
-
Snapshot build taking nearly an hour
Hi - I have a table of approx 25m rows looking up to 2 other tables to retrieve 2 values. I then have a new column transformation with a simple if then else formula based on the two retrieved values - I'm creating a snapshot from this output and it it taking nearly an hour to create. Would this be expected.
-
Find duplicates functionality, duplicate matching and duplicate record resolution.
Hi community members We're looking for customers and external evaluators of Aperture Data Studio that would be prepared to participate in some field research on the topic of duplicate record matching, identification and resolution. This is an opportunity for you to influence some of the work that we wish to pick up in theā¦
-
Dynamic Naming of Output File
Hi, Is it possible to have a dynamic text element of the naming of an output file. I understand that the naming can consist of a text and date stamp, however does the text need to be static or can it be dynamic based on content of the output file. I essentially want to extract a reporting date from the output to beā¦
-
Error with resuable workflow step in new workflow
Hi, I have created a workflow that produces an output and has been made reuseable. This workflow is then used as the start of a second workflow and previously the second workflow has run correctly. However now the second workflow is causing errors and when i click to see output of the first workflow within the secondā¦
-
ODBC: connection failled
Hello, We are facing some issues when we try to apply ODBC procedure (https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/use-odata-and-odbc/access-data-using-odbc/) We have the message: Failed to authentificate For your information, we tested the connection with 2 aperture accounts: administrator user,ā¦
-
Dynamic DataSet Naming
Hi, We are trying to use Aperture V2 as part of the ETL workflow. We need to pick the data set from a landing zone. The challenge is that the incoming file name follows a pattern i.e. static text followed by Date/Time stamp. Aperture workflows pick up Dataset with fixed name only. It allows to change the file name whileā¦
-
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 it is xxx oy in another system it is xxx only. There are many scenarios like that. So do we have any feature in Aperture to identify with Fuzzy Matching Technique?
-
Document Data Lineage in my Aperture installation
I have recently joined a company using Aperture to manage their data quality. They have set up several Spaces, each of which have some of their own Datasets and some views shared from a central space. I would like to have a clear picture of all the database objects that have been referenced in datasets, views and workflowsā¦
-
Error when running workflow
When running a workflow I get the error message - One or more workflow steps are invalid - but no indication of which of the 20 or so steps might be a problem - is there an error log that will tell me the failing step?
-
How to Capture Trend of the DQ Scores
I have rules created and I have scheduled the rules to run on every weekend. Now how can I capture the trend Suppose in week 1 my DQ Score for rule 1 is 65 %, wk 2 Data cleansing is done and DQ score increased to 70% wk 3 it is 75% how can I capture this trend in the graphical format?
-
Length of the maximum number of columns?
I'm trying to import database table data into Aperture, but I'm having a problem with the length of the column (if itās quite long, maybe over 100 characters). For example: My column in the database: example1@exampledomaim.doc, example2@exampledomaim.doc, example3@exampledomaim.doc, example4@exampledomaim.doc,ā¦
-
Importing and Exporting Workflows
One of the very first things that you will probably wonder, is just how portable are my workflows that I create in Data Studio? The answer is simple. In v1.x if you have a workflow that you have created, there are some dependencies but as long as your source and target environments contain the same sources andā¦
-
Exact match, fuzzy match and de-duplication with Find Duplicates
Hi everyone, I'm starting a series of articles all about matching and linking records to find duplicates in Aperture Data Studio with the intention to encourage some learning and interaction. Start here: Why worry about duplicated data? Simple ways to identify and resolve duplicated data in Aperture Data studio: Exactā¦
-
Do we need license for the Data Consumer
We have many Business users and want to give them only read access to the reports so we just want to give them Data Consumer Role. So for Data Consumer do we need License?
-
How to get distinct value from a column
ex I have company value in a table with contact details one company has multiple contact and now I want to get the distinct value of the companies in the contact table
-
Data dropzone - additional columns
Hi! I'm involved in a piece of work at the moment where we're using Aperture to map data in preparation for a data migration. The pre-existing data can be imported using a database connection, however the templates which I'm mapping to have been provided via excel spreadsheets. The challenge I have is that there are newerā¦
-
Join after a filter
Hello, In Aperture 2.2.6.118 , when we use a join function just after a filter , we get error message whern we clic on show step result of the Join step: Index: 2, Size:2. When we remove the filter it works very well. Thank you in advance. Best regards
-
ļ»æ ā¹ļø ļ»æ Removing Exact Duplicates / Exact Matches
A common thing users want to do with Data Studio is remove rows with (exact) duplicate values in selected columns, similar to the functionality in Excel 'Remove Duplicates' that will compare values in the selected columns, keeping the first of any exact matches, but also keep the values from any unselected columns in thatā¦
-
How to assign a variable value to a new column created in Transform
I am creating a new column (X) in Transform and I want to assign the value I created in the previous/same transform in another column (Y). How can I populate X with the value of Y column How can I select only specific columns to move forward in the next Transformation,. If I am having 100 columns in my current Filterā¦
-
How to assign a variable value to a column value
I want to assign the value of a column to my Workflow Parameter value. Ex. I have list of the columns like (Rule name, Group Name, Failed row, Passed row etc), I have workflow parameter "DQ Rule". Now I want to assign value of "Rule Name" to my Workflow Parameter "DQ Rule"
-
Match Records
Good Day, I have two datasets can I match them and get the records that matches either by company name or vat number or email domain
-
Can I integrate Aperture with Collibra
Is it possible to Integrate Aperture to Collibra? And then showcase the Rules created in the Aperture, display the same in Collibra Dashboard?
-
Can I Consume API in Aperture?
How can I consume API in Aperture or how can I read/parse XML or JASON in Aperture
-
Scheduling workflows using the Data Studio REST API in version 2
In v2.0 of Data Studio, the REST API has changed from v1, so this original post has been updated for those changes. Aperture Data Studio is intended to be invoked from third party schedulersĀ , likeĀ Windows Task Scheduler,Ā CronĀ or even triggered from workflows within other applications. The method for doing this is to useā¦
