-
A solution design for validating multiple mixed file schemas
We've recently been working on a solution to the following ask: A user has hundreds of data files in different schemas Each file has an accompanying metadata file, defining expected attributes (columns, datatypes, primary keys, lengths) We want to be able to load all these files, and validate against the schemas, to find…
-
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…
-
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…
-
Best practices designing complex Workflows
A Workflow is a sequence of steps that defines a process to transform and manipulate your data. When a single Workflow tries to tackle too many actions it can become difficult to read, understand and manage: If you are designing a Workflow alone this might be fine, but if you are collaborating or planning to have others…
-
UX Improvement - Output label case sensitive
What problem are you facing? The Workflow step output names/labels are being all converted to lower case when the reusable workflow is added inside another workflow. What impact does this problem have on you/your business? It makes it more difficult to distinguish between outputs, especially when there are several, which…
-
Drop-down picklist instead of free text entry for re-usable workflows
What problem are you facing? Currently re-usable workflows allow a free text input option, which suggests most recent entries. The value entered will be used in processing within the workflow, often relating to fields/data to use for matching etc. This leaves risk of error, if the user enters a typo, which could result in…
-
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…
-
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…
-
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…
-
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…
-
Profiling many datasets of different schemas
To profile thousands of datasets easily, you can create a reusable workflow with a replaceable source. However, if each of the datasets have a different schema, you will have to determine what is the most number of columns a dataset can have and use a generic schema with generic column names in your workflow. Assuming your…
