Route

🔷 Route Function

🔍 Definition

Routes are used for:

➡️ Determine the data path/sequence (route) based on:

the value of a field
and sorting results

👉 Simply put:

Assigning a “track sequence number” or “position marker” to the data

⚙️ Parameter

1. 🎯 Routed Field

Fields used as the basis for routing

2. 🔀 Include Sorted Field (Y/N)

Y (Yes) → sorting result fields are taken into account
N (No) → based on routed field only

📥 Input & 📤 Output

Input

All fields from the previous process

Output

All input fields
➕ new fields:
```
    route 
```

🧠 How it works

The route will:

Grouping data based on routed fields
Sorting (if there is previous sorting)
Labeling routes (paths/sequences)

🧪 Simple Example Data Input:

    MSISDN      LAC         EventDate
    --------------------------------------
    62y1        41126       20151206035741
    62y1        1126        20151206080941
    62y1        1126        20151206135355
    62y1        1118        20151207000101
    62y1        1118        20151207085428
    62y1        1126        20151206135410
    62y1        1118        20151207090057
    62y1        1118        20151207090416
    62y1        1118        20151207101327

Group And Sort

    Grouped Field       :MSISDN
    Sorted Field        :EventDate (ascending)

Parameter 1

    LAC,y

Output 1

    MSISDN             Route
    -------------------------------------
    62y1xxxxxxxxx      20151206035741-41126,20151206080941-1126,20151207000101-1118

Parameter 2

    LAC,n

Output 2

    MSISDN             Route
    -------------------------------------
    62y1xxxxxxxxx      41126,1126,1118

💡 Important Note:

The useful output fields from this buffer function are the grouped fields and new fields. Add a Transformator (

) assembly afterward to select these fields.