-
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 š
-
Why do the dates not match in this function?
Hi, We are trying to write a Function that checks to see if a valus is a date and, if so, formats it (for consistency). It then does the same for the other date and compares. Using the parameter values below it doesn't seem to recognise them as the same date and returns a false when the dates are the same, just that theā¦
-
Exportable Object Endpoint via REST API for Change Tracking and Audit
As part of our ongoing efforts to manage Aperture using Aperture, we would like to use the Aperture API to audit the workflow objects in each of our spaces. This will allow us to spot new workflow build & validate that against build plans and data governance records. Currently our view of workflows is limited to fullyā¦
-
Notification filters
Let's say I have 100 workflows and would like to set up an automation to send me email when they are completed, except for 3 of them. Is there a way to exclude those three from triggering the automation? In the filter settings for the triggering event I can add a "Workflow is not equal to" filter but it only accepts oneā¦
-
ADS, not enough permissions for page.
user is admin to the workspace. what could possibly be the reason for her not to see the dashboard in this workspace?
-
Aperture Data Studio - Find Duplicate Servers
Hello Community, Our organization has recently decided to use ADS for Data Quality tool and we are trying install ADS setup in High Availability setup in AWS Environment. We are trying to install Data Studio in a EC2 instance as per the Documentation and several Find Duplicate instances in 3 availability Zones. Help in anyā¦
-
TLSv1 and TLSv1.1 protocols disabled by default in Data Studio
Towards the end of 2021, TLSv1 and TLSv1.1 protocolsĀ became disabled by default in Java 8, on which Aperture Data Studio is built. As a result, when you upgrade to a new version of Data Studio, if you are using Data Studio's packaged OpenJDK, you may find that some connections to External systems (e.g. JDBC) no longerā¦
-
A Function with two parameters is not showing up in a workflow
I created 2 parameter Re-usable function its working and showing results. When I try to use it in Workflow its not coming in the functions list please let me know if I am missing any thing.
-
Relationships in Aperture
In Pandora we have option/facility to see the relationships between datasets/tables. In Aperture do we have that if so help me on how we can see them.
-
Keyword: Community - Data Management User Group Material 09th March 2023
It was great to meet the Experian Aperture Team and fellow users last week. Just wondering if and when the slides and any other additional material (Q&As etc) might be available and whether they'll be emailed or shared via Download? Would be really useful to walk through with colleagues that couldn't attend and to provideā¦
-
Find Duplicate is showing empty records along with input records
We are using remote duplicate store. Whenever we run the workflow, the Find Duplicate step's result is produced the cluster id and and Match status as expected for the inputted data set. However, there are many blank records in its output, all of such records are showing their "Duplicates: Action" as "AFFECTED"; and forā¦
-
What is the Aperture Data Studio equivalent of TABLE LOOKUP in VALIDATE in Pandora ?
We are migrating DQR's from Pandora to Aperture Data Studio. Pandora has TABLE LOOKUP functionality in VALIDATE and I am trying to convert to the same in Aperture but I don't see any TABLE LOOKUP component with in VALIDATE when trying to create the DQR. TABLE LOOKUP in Pandora is being used to get a Minimum value of aā¦
-
Aperture Data Studio update ā March ā23
Whatās happening? Aperture Data Studio has been updated to v2.10. This latest version includes new features. Download and install the latest version. We highly recommend that customers upgrade at least quarterly to ensure the best experience and have their data protected to the highest levels. For hosted customers, thisā¦
-
Number of columns in a dataset or a view
Hello, How do we know the number of columns in a dataset (or a view) when we are in a workflow ? Thank for your help Best regards
-
Find Duplicate new feature compatibility
We are using 2.9.6 ADS version in our prod serverand we have WFs to replace the existing duplicate store data. Now we have upgraded Latest ADS version 2.10.2 in our DEV environment and we see that Find Duplicate has lot of new functionalities with some new components. For our existing wf we still want to go with the sameā¦
-
Aperture Data Studio quarterly newsletter ā Marchā23
Weāve recently updated Aperture Data Studio to the latest version, v2.10. You can view the interactive product roadmap to see the current state of deliverables as well as the plans for future development. You can find out all the details on our community page. Whatās happening? This latest version of Aperture Data Studioā¦
-
Pivot grouping issue?
Hi All, I have an issue with the pivot and I'm not sure how to solve this or what function to use to get a similar arrangement! I would like to arrange my dataset so that I see all vendors in one column grouped and all the other data columns arranged in further columns: Normally the column selected as the "pivot ID" shouldā¦
-
Make "max number of columns" a variable
Hi All, Is there any way to make the max number of columns value a variable? I do not always know prior how many cases will I have so I would like to add a variable that could be for example the result of the list-count. Many thanks! Kind regards, Vera
-
Validation - order of rules
Is it possible to arrange the sort order of rules (possibly by manipulating the Order number within a Validate step)? Thanks Nige
-
Find Duplicate Step's result is not showing up
In the Find Duplicate Step, after configuring input data set, duplicate store as Temporary Store and Step Setting, the link for "Show Step result" is disabled as well as the exclamation mark at the top right corner of the step is showing "Coudn't reach Find Duplicate server"
-
How to invoke a stored procedure
I wanted to execute a stored procedure from the workflow as its first activity. My credential has the required permission to execute the stored procedure which is created on SQL Server DB. The stored procedure takes care of creating a new entry to the log table with the information such as start time, 'Started' as theā¦
-
Replace function
Hi there, I am trying to make a function to replace some values with null. I did it with on value but wanted to add more so I can clean more with one function. Can you help, please?
-
How to export workflow result to Snowflake table
Hi, I have a scenario, where I want export workflow processed dataset to be exported/pushed to snowflake database What are the possibilities.
-
running multiple workflows through rest API : UNKNOWN: 2046: Session is invalid or has expire
Hello dear team, when we run 4 workflows using a rest api (via Talend job), we are getting error message {"reason":"Unexpected error","details":[{"errorCode":22001,"detail":"io.grpc.StatusRuntimeException: UNKNOWN: 2046: Session is invalid or has expired"}]} We notice that this happen sometimes after the execution of theā¦
-
Regular exression match not found
Hi All! I would like to create a Regular Expression match check for the whole number 3 in a string. The regex would be: [^.][3]|^3[^.] Although in the result you can see that it is not correct - the 4th line should be true as it contains 3 as a whole number. I've tested the Regex at https://regexr.com/ and it is showingā¦
-
Unique ID for Validation Rules
Hi, Is there a way of exposing the unique ID for a validation rule, either via the API or another mechanism? The reason why I'm asking is because we've started reporting on our data quality testing across the company, based on the validation rules being run by each business area. At the moment the only way that we canā¦
-
Joining to Validate Function, but keep Validation Formatting
Hi, I have a Validation step, it works perfectly. However, I want to append an additional column via join. When I apply the join the Validation functionality (i.e. status changing colour, drill down to see rules no long available). Is there a way to join without losing that functionality. Or maybe some hack? What I amā¦
-
Set default to always ignore NULLS
Hi, I am doing sever DQ checks on a single field within a validation step. On each of these checks I want to skip the check if the field is NULL (i.e. so only performing the check on the populated cells). To ignore, in each function I am doing the normal test (e.g. DoB is Date), and also a IF THEN ELSE, to ignore whereā¦
-
Has anyone else had issues connecting to an AWS RDS server? And if so how did you manage to connect?
We are having issues connecting to an RDS server, the port is definitely open and the username/password is correct. We have tried putting encryption parameters in but still won't work. Our non-RDS servers are working perfectly, it is just rds with the issues.
-
Get the 6 month Older Date from Today
Is there any easy way to get the date which is 6 months older than today?
-
Sending email to stakeholders through Data Studio Dynamically
Hi, We want to send the email notification to the users who are creating issues example creating duplicates. we have a list of the xx column on which duplicate has been created by Y number of people. Now we want to send this to Y number of people, which is not a fixed list. How can we do that dynamically. Is there a way toā¦
-
Please make Rows per Page configurable
This is a suggestion for improvement. Please make Rows per Page configurable per user. I prefer to 50. (100 if available). It is a pain having to manually change this too many times. By the way, Is there any work-around to keep it at 50 always?
-
We are due for license renewal for address validation API. Whom do I contact?
We are due for license renewal for address validation API.Ā Whom do I contact? I don't have account manager contact with me.
-
š£ Join us in person at our next UKI Data Management User Group I 9th March 2023 š
I am pleased to confirm that our nextĀ UKĀ Data Management User GroupĀ will take place onĀ Thursday 9 March 2023, 10.30am until 3pm London UK time, and if you are an Experian client based in the UK you can sign up today. This time we are excited to host the event at our newly refurbished offices in Cardinal Place, 80 Victoriaā¦
-
Functions - suggested product improvement
Hi, When working with a list of functions, every time I edit/publish/share one it returns me to the top of the list and I have to find my place again to do more work on the same Function - not essential, just a bit frustrating... Currently using v2.9.6 Any chance of making an amendment so you are returned to the sameā¦
-
Uniqueness and/or Completeness as a validation rule
Hi, I know we have the profile step and the validation step in a workflow, but how can I create a validation rule for uniqueness / completeness so that the results are in the validate step results. thanks
-
Copying transformations
Josh made some comment in the User Group the other day that it was now possible to copy and paste logic and I was most interested in how this was done. I have a massive transformation to process addresses in the HR data that I am working with and now would dearly like to use that as the starting point for similar work onā¦
-
Lookup step returning unexpected values
Hello. I am currently using version 2.8.8.27. I've discovered recently that in one of my workflows, the Lookup step is not returning the expected results in all cases. I have quickly set up a test scenario I have attached below. The idea is the following: The lookup should give back the "Value" column's values in casesā¦
-
Inner Join Workflow
We use the inner join workflow to look at the matching unique ID between 2 sources. This is used for monthly reporting and validate what information changed on specific columns between the months. Is there a way to add more than just 2 sources? The join function only allows 2 sources to do a left, right, and inner joinā¦
-
Dataset Update through API
We have a requirement to Update the Dataset with API. Currently we are manuall placing the .csv file to the dropzone and then updating the Dataset. But as we want to automate this we want to call the API from the other server and update the dataset in aperture. Is the below api we can use to update the Dataset or it onlyā¦
-
External Rest API's
Afternoon, I'm new to Aperture and wanting to know if it possible to bring data into Aperture though a Rest API from an external company we use, for example QuickBooks, Zendesk, Sage etc. The idea would be to create workflows of the back of the Rest API data in one centralised location. Thank you for your help in advance.ā¦
-
Adding views to a space
Would it be possible to make an enhancement to permit the searching for a particular view when including from another workspace please. It would save having to page down when there are many that are shared..(and easier to find them in a big list) Thanks
-
Consumer users accessing/updating issues
Hi - Does anyone have any knowledge of consumer users accessing issues? I've set up the consumer users as having access but users are getting a message that they can't access. See attached
-
Thresholds in validation step
Hi, Sorry me again! I was just wondering if the thresholds, which are set at rule group level can be accessed anywhere to add in to snapshots for reporting and dashboards? Have included a couple of screengrabs of the bit I mean, at the moment I couldn't see this in any of the outputs from the validation steps. To give aā¦
-
API to Get Scheduled Jobs Information
There is One API to get the information about the scheduled Datasets. But in that we have to Pass the Space Names to get the info and Response is specific to that Space Alone. Is there any API where we can get the Scheduled Dataset Information across all the available spaces? I am using below API but it gives response forā¦
-
Function for duplicate SSN's
Hello, My first post in the community so please bear with me. Trying to create a function to catch duplicate SSN's. So far, my preview is not working once all of the J Segments are added in. The function that needs help is: Create list: Base + all J segments>is empty>is true Equals (invert output) BaseSSN=input valueā¦
-
Converting the Numbers in the stats to the Nordic Number Format
We have this chart, where in the Vertical we have some numbers which are in format N,NNN we want to convert that to N NNN is that possible in any way? In Stats also we have the Number like Below in Current but we want in Required Format
-
It is possible to use the SharePoint Online list as data source?
We have a Sharepoint form with information. The form contains some columns and rows. Is it possible to collect source data with Aperture?For example. I have collected SharePoint source data with the Power BI tool. What about Aperture? Maybe in the future?
-
Duplicate Triggering of workflow with datadropzone
2 questions please: When a file is dropped in the datadropzone, it gets removed almost instantly. Sometimes, we don't even see the file in the folder. So users think the file is not processed and so they submit the file again. Q1. Is there a way to see if the file is picked up? (Especially for data consumers, who cannotā¦
-
Java pid hprof crash files.
Facing the issue in our dev server for Aperture Data Studio and Find Duplicates. In log I have found this at the same timestamp when I got the crash file in installation dir. 2022-12-14 05:20:12,255 ERROR c.e.m.a.MatchInstance [pool-157-thread-1] An unexpected error occurred when running Find Duplicates step againstā¦
-
Issues Lists - notifications
Hi everyone, I'm looking at setting up some issues lists for the first time, and I have a question around automations. Is there a way that I can get Aperture to send an email to a user, to notify them when they have new issues in an issue list? I only want it to send when there are issues assigned to that person. Thanksā¦
-
Replace Matches function returning custom columns?
Hello. I have a large table in which I would like to replace certain values with a lookup from a static dataset. (Example below, I'd like to replace the "..." placeholder values with the actual correct ones from the static dataset) Basically what I would need is the option to choose the return column dynamically so that Iā¦
-
Test if field contains only white space
Hi, I am still new to ADS. I have fields that contain just white spaces (1-3 spaces in a row [" "]). The ISNULL test does not FAIL these as it is not technically NULL. Is there a test for this? Note I cannot exclude every field with a space " " as many are valid spaces between two words. Thanks
-
Rename Widget without Renaming the View/Chart
Hi, is there a way to rename widgets in a dashboard without changing the name of the view/chart/dataset. Reason I ask is I have naming conventions to keep my data organised, I can update source name but if way to just change chart that preferable.
-
Java Update - Vulnerability detected on our Experian Dev/Prod Server
This version has been detected as vulnerable by - OCPU-2022-JUL: Oracle Java Critical Patch Update Advisory - July 2022 when we try to update this, I am receiving this notification, Do we need to switch to OpenJDK, or can we keep using below, and proceed with Updated, I am confused how all of this affects Jar files we haveā¦
-
Join us Online for our next Data Management User Group | 15 September 22 !
I am pleased to confirm that our next UK Data Management User Group will take place on Thursday 15 September 2022, 10.30am until 3pm London UK time, and if you are an Experian client based in the UK you can sign up today. Weāre also excited to confirm that this will be our first hybrid session. The event will be hosted atā¦
-
Can we add a hyperlink to the e-mail notification?
Hi! Is it possible to add a hyperlink to the e-mail notification? It would be a nice feature to be able to add a URL or a direct link to the export folder where the exported files are located. Many thanks! Vera
-
Is it possible to have dtill down in Charts /Trend
I have trend where I am showing some stats based on the month , I have also information available based on the WKs. But in the Trend chart 1st I want to show the By month Stats . Now in Trend 1st I want to show the trend by month , and then there will be options to drill down more to weeks , Is it possible to do that nowā¦
-
Row to Column after validate step
If I am using row to column step after the validate step then using Sum to remove the null and get it in one row then the interactive dataset is not working which works after the validate step.. till row to column step I can store it in interactive snapshot but after that if using Group to do sum then not working, also Iā¦
-
Adding datasets from database views
Hi, I'm currently uploading datasets in Aperture from a SQL database, a total of 15 tables were ingested with no issues but it seems that the process does not work for views and no error message is raised. Are there any extra steps to enable the ingestion of database views by Aperture? Many thanks in anticipation Bestā¦
-
File name as a parameter in export
Hello, I hope you're all fine :o) In a workflow, we use a dataset (which has as source a file), later in the workflow we export the result. Is it possible to use the file name of the datatset as an export file name ? Or at least, could we create a function which do: 1- use the file name as parameter 2- export the resultā¦
-
Using Columns-to-Rows before a join.
Hello. I'm using version 2.8.8.27 and have encountered the following phenomenon. When using the Columns-to-Rows step and using a Right-unmatched or Full outer join after it, all the rows that have no match in the Left table are still populated with the first row of the Left table. The expected result, at least for me wouldā¦
-
Aperture Data Studio backups
@Henry Simms , what would be the equivalent link to this according to current version. https://www.edq.com/documentation/aperture-data-studio/help/#backup this link seems to be broken, maybe it pointed to some old version or documentation. regards, HS
-
how to find Dataset & External Systems dependency
I tried with API to get the list where I can find the list of the Datasets along with the external systems it belongs to. But in the Dependon part I am only getting the List of the external systems on which any datasets are depending in the specific SPACE but not getting the info which Datasets are depending on thoseā¦
-
How to delete Duplicate external systems and tag dataset with the actual one
How to delete Duplicate external systems in a space and then tag datasets that belongs to that external system to the unique external system name.' ex. I have database abc in my space I see another external systems with same cred is there as abc1 (might be created or cloned when copied one space to other or one env toā¦
-
Snowflake Issues with Dataset Creation
We have deployed the proper snowflake drivers and have successfully connected to a hosted warehouse. Initially we had some sporadic failures connecting, but feel it might be related to the "Auto Close" or "Auto Shutdown" options in Snowflake. We increased the timeout value on the connection string and it seems to haveā¦
-
Dynamic SQL statement
I've set up a re-usable workflow. I'm trying to set up a dynamic SQL statement to execute in the pre SQL setting of an Export step. Is it possible to assign a Workflow Parameter to a setting in a step?
-
Can I create Interactivity Snapshot when unioning multiple Profiles from different datasets
Hi, I am new to ADS. I want to make a dashboard a single widget, the widget would be the profile results of 2+ different tables To do this I have profiled two tables, and have unioned them. I then take a snapshot of the union. However, when I create a new dataset as part of the snapshot step, I do not have theā¦
-
How-to Video clips
Hi Are there any plans to create any more 'how-to' video clips? And if so, can these be stored in a separate section in the Community Site. I have found the ones created in Resources but with the product being developed it would be great if some of these could be updated with the new product features. I also recall seeingā¦
-
Aperture Data Studio quarterly newsletter ā October ā22
Whatās happening? Aperture Data Studio will soon be been updated to v2.9, with notes and downloads available here We highly recommend that customers upgrade at least quarterly to ensure the best experience and have their data protected to the highest levels. For hosted customers, this release will be implementedā¦
-
Connecting to a database with a different schema
Is there a setting that needs including to be able to pull data from a different schema from the same database? I keep getting an invalid object name error - I've attached the setup.
-
How can I configure TLS for the Find Duplicates Workbench
What are the steps to configure an SSL certificate for the Find Dupes Workbench site? I already have the Workbench installed as part of Data Studio and running on http://localhost:26312/
-
Validate Email Domain. Accuracy?
Hi, I have the validate email address (domain) function up and running, but I am not sure about the accuracy of the results. For example, the following email gets flagged as bad, even though the domain is real (you can google it). FYI I am using Amazon AWS DNS server (169.254.169.253) in the Aperture settings.ā¦
-
SSL certificate about to expire. need to apply the new one.
Data Quality user documentation | Security (experianaperture.io) This documentation for applying SSL cert if quite confusing as I do not see the menu. Go toĀ ConfigurationĀ >Ā All server settings do I need the pfx file, or I can just apply cert file to update SSL. pls let me know. @Henry Simms your response would beā¦
-
Load All Columns as Alphanumeric overridden when loading Excel Workbook with multiple sheets
When loading multiple worksheets from a single Excel workbook, the columns are auto-converted rather than being loaded as alphanumeric as specified in the options. Splitting the sheets into separate workbooks allows the data to be loaded as required. Is this a feature or a problem?
-
Workflow - Export to Dataset, then Refresh
We have a workflow that is compiling some results from several steps (into a union), and then exporting to a JDBC external system with a defined dataset. As a last step, we have linked the export to the source of the defined dataset assuming that once it has exported the data, it would refresh the dataset, and we could seeā¦
-
The Group in the pivot seems not working perfectly
The group in the pivot is not working perfectly and it is not arranging the values into columns as it should. We noticed that it is when we also have a sort before the pivot step. We had the same issue in version 2.4 and it still remain in version 2.8.8. Has anyone else faced this issue? Have you found any work-around?
-
Can we schedule Reporting Jobs from Aperture?
Is this possible to trigger the Jobs in Reporting from Aperture Ex. Power BI Qlikview Ex. after a successful run of Aperture WF need to trigger the Report in Power BI, that dependency can be created through aperture schedule?
-
Calculating values from N number of columns
Hello. I have a dataset which contains Keys, some additional important data I'd need to keep and then 12 columns of values (Value (M1), Value (M2), Value (M3) etc.). Depending on how many months we have left in the year at the time, I have to add N number of columns together (right now, we have October November andā¦
-
Incrementally Loading Datasets
I've thought through a few different ways that I can use to incrementally load a dataset using batches in the dataset and views on the source side. However, I'm wondering if anyone else has done some work around that and would be willing to share their thoughts / ideas. Essentially we have some really large tables which weā¦
-
Is there an easy way to filter out records which contain a number only (for a given column)?
I need to filter out records which contain a number only from an address column. I have attempted to do this using the To Number and Is Number functions: This approach does not work because the To Number function does not behave as I would expect it to: Why does 2 Street and 4Street not return the Invalid number error? Canā¦
-
Error Groups
Is there any way, having set up a number of Error Groups in a workflow, to propagate these into another workflow? Nb It would also be great if the default Dama DQ Dimensions (below) were available 'out of the box' Thanks Nige
-
Error when refreshing dataset - "Unable to get tables."
I've not seen this error before and I'm unsure how to resolve other than dropping and recreating the dataset. I have a dataset that has been established for a few months. It uses a SQL query versus a specific table. Over the last several days, we have seen error notifications that the data cannot be refreshed when ourā¦
-
Batch timestamp format
I've created a number of DQ outputs running of a scheduled workflow to create a multibatch dataset of results over time. Unfortunately the batch timestamp although referenced as date/time, is not read as date time by excel or Power BI. Is there a format setting so that batch timestamp can be seen as date format in otherā¦
-
Why doesn't the Replace Matches function work in some specific cases?
I am trying to use the Replace Matches function within Aperture, using the Comma Separated Input Type: This goes wrong when the field has a space in it, as in th 7th and 12 entries in the sample below, presumably because both Wales and Ireland are also in the lookup table.: Surely it should be the Whole Value if there isā¦
-
Why can't I select a file from an SFTP server
I am trying to Add Dataset from an SFTP server and can see a list of 29 files. I am at the Select Table stage. I select an xls file and click on the "Next: Define Settings" but while the button greys for a second or two, I come back to the same Select Table screen
-
Why in Aperture can I not see today's log file?
-
Version 2.7.5 Delete dataset bug
We identified a bug in version 2.7.5. When trying to delete a dataset, the confirmation screen asks to confirm some other random dataset name! So not sure which dataset would be deleted. Has this been identified before by anyone? Is it officially fixed?
-
Created date columns
Created date columns. They converted to alphanumeric. When I try to perform a compare date/time of the two newly created columns, the error is "Not a date". Can the new columns be converted to 'date' datatype?
-
Datasets not refreshing automatically
Hi, We built an integrated set of schedules and workflows that allows data from existent datasets to be refreshed on a daily basis. However, the refresh only happens if it is done manually per dataset. It was noticed when the dataset A (OBJALG as per screenshot) was refreshed, the number of records should have increasedā¦
-
Does Aperture have the "treat leading zeros as alphanumeric" option that Pandora had
One a a global setting that instructed Pandora to treat any input field with leading zeros as alphanumeric so that the leading zeros were preserved. While I can see that one can set a field which has can have leading zeros as alphanumeric, this seems to require an analysis of the data to know that it has leading zeros -ā¦
-
Select first three records in each cluster
Hi After running a Find Duplicates step at individual level I can see that we have many contact names for some business, so I want to cap these to three contacts for each business address. I'm thinking I should run another Find Duplicates step with the Household step setting to get clusters of businesses, but from thereā¦
-
Function for similar characters
Hello, I would like to create a function that will show as "false" when a column (E.g. consumers first name) has multiple of the same characters in a row. 'John' or 'Matt' would be pass, while 'Samuuuel' or 'Mattt' would be the fails. I was able to create one using the "substring" and "in length range" functions but thisā¦
-
Filter for date range
I would like to filter in a workflow for dates within the last 7 days from today. Right now the only way I can see how is to have two different filters. The first filter step takes the current date and time, subtracts 7 days, and then uses a "Greater Than or Equal To" step. The second filter step takes the current date andā¦
-
Read from one space, write to another
Forgive me if this question is easy to answer; still getting up to speed after implementing Aperture Data Studio earlier this year. So I have some rather large datasets that come from our data warehouse. There are different use cases that require reading data from these and writing to someplace (JDBC database, Snapshot,ā¦
-
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ā¦
