...

You will reformat post codes to remove all spaces, and ensure that all letters are upper case:

1. In your model, add a new stream:
   1. Hover over Customer Details with Region, and press Image Modified Add a new Stream
   2. Give the new Stream the Name: Reformatted Customer Details
   3. Drag all attributes from Customer Details with Region to the new stream
2. Open the configuration form for Reformatted Customer Details
   
   1. In the Attributes section, add a new attribute:
      • Press Image Modified
      • In the attribute details form that pops up:
      • Set the Name: ReformattedPostCode
      • Leave the settings for the attribute as default (Type is String, Length is 50)
      • Set the Attribute Expression to

toUpper(replaceAll(in.PostCode, " ", ""))

...

Now you will generate a short code for counties by taking the first 3 letters of the county for each customer detail record:

1. Add a new attribute called CountyShortCode
2. Leave the default settings

3. Set the attribute expression to

   Code Block
   substring(in.County, 1, 3)

   
   

4. Press Image Modified

Categorise bills as "LARGE" or "NORMAL"

Categorise bills as "LARGE" or "NORMAL":

1. Add a new attribute called BillCategory
2. Leave the default settings

3. Start the attribute expression to:

   Code Block
   if (in.BILLAMOUNT > 10.0, "LARGE", "NORMAL")

   
   

4. Press Image Modified

Set special processing flag

Finally, you will now set a special processing flag – this will be set to "YES" when the last bill for the customer is large. To do this, we need to access an attribute value in the stream, but which is not in any of the input pipes to the stream - only in the stream output. To do this, you will use the internal variable _out:

1. Add a new attribute called SpecialProcessing
2. Leave the default settings

3. Start the attribute expression with:

   Code Block
   if (_out.BillCategory == "LARGE", "YES", "NO")

   
   

4. Press Image Modified

Run stream

1. In the main stream configuration form, press Image Modified
2. Remember to save your model layout.
3. Run analysis on Reformatted Customer Details
4. Have a look at the data in the new stream – check that all your transformations have been correctly applied