In this tutorial, we will create a simple dataset for a time dimension.
Note
In Chapter 2, Getting Started with Transformations, you created a transformation that generated a dataset with one row by date in a date range. In this tutorial, we will reuse that work.
First, we will create a stream with the days of the week:
Create a new transformation.
Press Ctrl + T or right-click on the canvas and select Transformation settings to access the Transformation properties window.
Select the Parameters tab and fill it as shown in the following screenshot:
Drag a Get Variables step to the canvas, double-click on the step, and fill the window, as shown in the following screenshot:
After the Get Variables step, add a Split Fields step and use it to split the field
week_daysinto seven String fields namedsun,mon,tue,wed,thu,fri, andsat. As a Delimiter set a comma (,).Add one more Split Fields step and use it to...