-
Customizing your Dashboard with the Custom content widget
Data Studio Dashboards can be configured by adding, ordering and resizing different widgets including Views and Charts. One of these widgets is the Custom content widget: Firstly drag the Custom content widget onto your Dashboard. Next add some text that your colleagues will find useful: Add style 🕶 To make this…
-
Combine Filter/Split step
Hi, I'm raising this on here as it's come up a few times with various users and I want to see what others' think of the idea to essentially combine the filter and split steps (which perform the same action, with the only difference being the split step allows users to view unfiltered results): vs I myself have found on…
-
Sticky Notes attached to Workflow step
Just a thought… but it would be really nice if Sticky notes could be pinned to workflow steps (I always provide decisions or descriptions of steps as part of knowledge transfer). That way if I move my workflow step the Sticky note comment moves with it (or worse, someone hits the auto-arrange button and now my Sticky notes…
-
Prevent object tags from requiring a workflow to be re-published
What problem are you facing? I have applied the new Object Tags to various workflows. In each case the workflow status changed from Published to Draft when the Object Tag was saved. The tags can be bulk added but the workflows must then all be individually re-published and a comment added. What impact does this problem…
-
Include Metadata in the Export step
What problem are you facing? I would like to include metadata in the export step (specifically in the JDBC option) that includes metadata for the target system and table (e.g. tablename, DBMS system, credentials used etc.) as this would help users / DBAs to debug/resolve any issues or be included in a point-in-time audit…
-
Importing data into Salesforce child objects
I have a user case to use out of the box functionality that come with Salesforce and is available in the Progress Driver to relate data in parent and child objects on import. In a Salesforce object you can designate a field as an external ID. When you load a child object such as Contact where the parent is Account and you…
-
Rows to Columns
Hi, I have been testing out the Rows the Column function. However, it seems to be not pulling through all the columns. In the DEV data set, I currently have 62 rows which I would like converted to columns. When using the Rows the column, it automatically only finds around 56. Wondering if anyone else has had a similar…
-
Experian API call to Execute Workflow
hi, Can someone help me with the JSON request to invoke a workflow through REST API? Below are my workflow specification a. Workflow accepts workflow parameters b Workflow accepts source at execution and its mandatory to give source information.
-
OUTPUT step in a workflow
Hello, rookie here again. I'm trying to understand the output step but the only thing I can find in documentation is below. When do you use an Output step? Where is the output located? how do you use the output step in another workflow, view, etc.? When a re-usable Workflow is using the Output step, the step's data will be…
-
ℹ How to use Functions in Workflows
Workflows Workflows is the area in Data Studio where designer users tend to spend most of their time. For anyone new to it, imagine a data pipeline that manipulates one or more data sources through a number of stages and then does something with the results. Whilst a Workflow is easy to build by connecting different steps…
-
♻ Reusable workflow example – calculate word frequency
Today I’d like to share with you a reusable workflow that I built a little while ago not only as a downloadable .dmx file (see below) for you to explore/use as you wish, but also as a means of demonstrating one of the key themes of Data Studio…reusability. If you find that there are duplicate tasks being executed on your…
-
Use a value in your data as the export file name
If you are looking to use a value in your data as the export file name, you may have looked at the Export step and realized that it does not allow you to directly select a value from your data as a filename component. However, you can actually use a workflow parameter as a filename component to achieve this. You will have…
-
How to specify parameters for embedded workflows outside parent workflow?
Hello, I'm designing a re-usable workflow (parent = test for community), which uses another re-usable workflow (child = Dynamic Flag). The child workflow requires two inputs specified at runtime - "source A" and "source B". I want to be able to choose the values for "source A" and "source B" when dragging the parent onto…
-
autoColumnMapping function in Workflow api
Hi, Have you consider having a flag in your api to execute Workflows to use the auto Mapping columns we can have in Studio ? This will be great to avoid case sensitive headers in DataSet for instance. Regards,
-
Workflow is not in an executable state but no errors exist
Hi DQ Community, I have a workflow that I can't run or publish because I get error messages telling me that one or more workflow steps are invalid, or that the workflow is not in an executable state. I've been through the workflow multiple times and all the steps are valid - I can open the final step and view results, and…
-
Error Encountered While Executing Workflow
I am attempting to manually execute a recently created workflow, but I am encountering an error. The message states that 'source 1' and 'source 2' must be provided to run the workflow, despite all my data coming from a view. I am unsure about the specific requirements it is asking for. Could someone please shed light on…
-
Want to pass certain input from API to the workflow
i am trying to call an API from an external website my agenda is to pass some IDs that will be taken as input in the workflow and the workflow will run for those IDs only and finally if i could export the result in some kind of file (csv,excel,xml)
-
Stored Procedure invoked from PostSQL of Export step is not processing all records
hi, In my workflow, I am connecting to SQL server 2012 using Custom JDBC jar (Microsoft JDBC Jar 12.2) and the connection string looks like below…
-
Error while running workflow
Hello, I am trying to run the newly created workflow manually and it is giving me an error. It says source 1 and source 2 must be supplied to run the workflow. All of my source data are coming from view. Don't know what it is asking for? Does anyone know what is the error about and how to fix it?
-
Using workflow'(s parameters
Hi dear community, I'm using Aperture 2.8.8 verison My use case is calling a workflow through REST and I need to provide some data as input (always in REST) in order to execute the workflow with these data. I'm thinking about using data as workflow parameters, then inside my workflo I will use these data and add them in a…
-
Parameter as a list?
Hi, is it possible to have a parameter use a list? So the same workflow gets run for a list from an input file? I have a report that I want to run, many times over based on a a county name from a list. Right now, I have to change the parameter manually. Thanks
-
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…
-
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…
-
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…
-
How to set up an export file name based on a fixed or variable input
In this article, we will be exploring a number of ways to set up an export file name. Imagine you start with a simple workflow where you have a Source step and Export step. You want to export the source data to a csv file on the server export directory. Use default export file name By default, the filename consists of two…
-
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?
-
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…
-
📽 📺 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…
-
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…
-
🎞 A Short Feature Demo on dynamic workflows in Data Studio
https://bcove.video/3ygaHTL
-
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"
-
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…
-
Triggering workflow executions upon file arrival in Aperture Data Studio v1 versus v2
Aperture Data Studio is commonly used for operational data quality management. This would mean that you are regularly pulling up-to-date information from multiple transactional systems used within your organization such that you can centrally perform data quality checks and improvements. This prepares the data for further…
-
Scheduling workflows using the Data Studio REST API
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 the Aperture Data Studio REST API to execute a workflow from within a script, and trigger that script from the…