-
Looping workflows
About the requirement Recently I’ve been asked a couple of times if it’s possible to cycle through a workflow for every value within a given column. This is mainly to drive 2x types of use case: Dynamic data export – effectively taking an input dataset and splitting it out into a separate file for each subset of data (as…
-
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…
-
♻ 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…
-
Zuora Source Timeout
We are using a JDBC Driver from cData to extract data from Zuora to a Dataset, some of the tables are 20 million rows. Aperture sends the query command to Zuora which produces a download file but it can take 10 minutes by which time Aperture has fallen asleep and the data is not imported. Does anyone know if there a…
-
Finance Format Number 💲
Summary This package contains a single function but may be updated in the future to include others. Finance Format Number 💲 Suggested by @Sharat Kutty, this function converts Negative numbers are put it in brackets so the number i.e. -100.23 becomes (100.23) and shows up as Red color. All 0 and above shows in normal color.…
-
Percentage functions 🧮
Summary This package contains a couple of functions but may be updated in the future to include others. Format Number as a Percentage 🔣 This is a function, suggested by @George_Stephen and intended to be used to help create a presentation form of percentages for use on dashboards/views. The function takes a numeric input…
-
Severity Identification for New Version Upgrade
Regarding installing releases, is there a way to easily identify the severity of each release made available? For example, if a new release came out with security features can it be easily identified whether that particular release contains an Urgent update for vulnerabilities that should be installed as soon as possible,…
-
Handling data from Experian Aperture Data Studio jobs
We are getting error in the execution of Experian scheduled jobs as "There is not enough space on the disk" We have installed the data from the Experian Aperture Data Studio on the E Drive (511 GB) out of which only 19 GB is remaining. Majority of the data is occupied in the E:\ApertureDataStudio\data\resource folder under…
-
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…
-
Attention all V1 & V2 users...
Today we have launched a new sub category, Migrating from V1 to V2, which contains posts to aid your transition to V2, as well as access to a migration tool. We will be adding more posts over the coming days and weeks so stay tuned for tips and tricks to aid your migration. Please note, you must be signed in to the…
