Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • In your model, add a new Stream:
    • Hover over Customer Details with Region, and press  - Add a new Stream
    • Give the new Stream the Name: Reformatted Customer Details
    • Drag all Attributes from Customer Details with Region to the new Stream
  • Open the configuration form for Reformatted Customer Details – double click on the Stream icon on the model pane
    • The configuration form will open on the Attributes tab
    • Add a new attribute:
      • Press 
      • 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
Code Block
toUpper(replaceAll(in.in_PostCode, " ", ""))
    • Press

In the left-hand menu bar press - Show the List of Attribute Functions. All attribute functions available in PhixFlow are shown. Find the attribute functions you used above – toUpper() and replaceAll() – and double-click each of these to see the help pages for these functions.

...

  • Add a new attribute called CountyShortCode
  • Leave the default settings
  • Start the attribute expression with
Code Block
substring(
  • Press  - Show Inputs
  • In the list of Inputs (the top window) select This
  • The list of Attributes (the bottom window) will update to the list of attributes available from the stream you are building. The other input, in, will give you the list of attributes in the stream that is linked to this stream by the pipe in
  • Drag the attribute in_County from the list of input attributes into your attribute expression
  • You will see that this adds _out.in_County to the attribute expression
  • Complete the attribute expression with: , 1, 3)
  • Your attribute expression should now say: substring(_out.in_County, 1, 3)
  • Press 

...