Route

In this document, you will explore how to route datasets in Astera Dataprep. A Route transformation routes the data to multiple datasets based on custom decision logic expressed as rules or expressions. This allows the creation of multiple sub-datasets from the main dataset with records being directed to different datasets based on specified conditions.

1. Open a Recipe in Astera Dataprep.

1. Navigate to the Toolbar and select Transform > Route.

1. Configure the following options in the recipe action in the Recipe Panel:

• Default Dataset Name: This dataset contains all the records not passing any rules defined in the Route transformation expressions. It is required to set a name for the Default Dataset here.

• Dataset Name: The name of the dataset that will contain data for the records that pass/fulfill its specific expression's requirements.

• Expression: Enter an expression (e.g., Region = ‘North’) or any condition you want to apply to your data. Each Route expression you add here will create its own Dataset based on whether the records satisfy the expression.

1. In the Route Properties, click on the expression text entry box to enter an expression. You can enter the expression here or click the button to open the expression builder. Click to approve and apply the expression.

1. In this example, we have created three datasets based on the value in the Region field: one for North_Region, one for South_Region, and a default dataset named Other_Region. Each dataset has an associated expression that routes records accordingly. Records where the Region is "North" are sent to North_Region, those with "South" go to South_Region, and any records that do not match these conditions are routed to the default dataset, Other_Region.

1. Click Apply to apply the changes or Cancel to discard them.

2. Once you click Apply, the routed datasets are created and by default, the first Route Dataset (here: “North”) is previewed on the grid.

1. The other datasets can then be read using the Read Dataset recipe action.

This concludes the document on using Route in Astera Dataprep.