Data Flows in v4 of Oracle Data Visualization (in the new OAC as well as Desktop) is much improved, so let's look at creating a flow to :
- Join together two datasets
- Filter the columns
- Create some bins
- Add a new calculated column
- Save the results as a singe data source that we can then analyze.
Our flow will eventually look like this .....
We will start with one data set I have created, that being a spreadsheet of ficticious sales people and their travelling and renumeration.
The second data set is a sheet of the sales people with the cars that they drive
So let's get the basics out of the way and load them both up as data sets ....