Welcome to the Beyond Blog

3 minutes reading time (506 words)

Oracle Analytics Cloud 105.2 New Feature - Transform in Dataflows

Transform
Oracle Analytics Cloud 105.2 ( and also the just released DV Desktop variant 12.2.5.2.0 ) have a huge selection of incremental updates and i've already covered a couple in previous blogs where I've looked at some front end visualisations.  The back-end Data Flow has also had some nice enhancements and we'll look at one of those; the Transform step.

Let us start with a simple dataset to manipulate.  Some fictitious schools and their pupil numbers.

 Let's create a dataset and use this as the source.

​We can now add some steps to the data flow to manipulate the data.  We now spot that there is a new additional option, the 'Transform Column'.

​In prior versions it was possible to carry out 'Transformations' but it required a few extra steps if we didn't want to retain the untransformed column.  For example let us say that in the resulting data set we don't want to see the actual pupil numbers, we want to apply a rule to determine if the numbers are above or below a threshold and see that as a text description.  Prior to having the Transform Column we could have created a new column in the dataflow, performed a function on that new column and then deleted the old column.  Now we can use the Transform Column and do it all in a single step.  We will apply the rule that if the school has over 200 pupils then it has 'A Lot' else it has 'A Few'.  When I add the Tranform Column it pops up a window with a number of features, one part of which allows me to click on the step name and change that to anything I want.  So below is the default name before I click on it ....  

If I change this to say 'School Numbers' then we can see that the step changes in the flow, so rather than just showing the generic step type, we have an icon of the type of event that is being applied and a name depicting what is actually happening.  This is useful to document the steps of the flow and make it easier to read.

I will now write the transformation statement as a simple CASE statement in the editor and then press Validate just to ensure that it is syntactically correct and then press Apply and we should see the column transformation take place.

Overall, quite a useful addition to the dataflow process.  There's actually been quite a few nice little tweaks added to Dataflows and I encourage you to have a look at the release notes to see them.  To finish let's have a look at a good aesthetic one.  Now you'll see that the flow we have is very small and thus we can benefit from seeing all the descriptions.  

Toggling the 'Show Lables' off as shown though really does compress the flow and with the addtion of the scaling will really help with the management of larger flows.
New Language Narrative in Oracle Analytics Cloud
It's all in the hands. Thoughts on conference pre...
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Wednesday, 13 November 2019

Demonstration

Request a demo of our products here

REQUEST DEMO

Contact

Beyond Systems Limited

Suite 1.01 Jactin House,

24 Hood Street, Manchester

M4 6WX United Kingdom

 

 

Tel:    +44(0)8450 940 998

Email:  contact@wegobeyond.co.uk