Page Comparison

...

• Create a new model: Attribute Scripting
• Drag the datasource CRM onto this model
• From the datasource open the schema browser, find the table SOURCE_BANK_ACCOUNT_TRANS and create a database collector from it
• Create a stream from this database collector – remember to use the  button in the hover menu so that the stream attributes are automatically configured
• Open the help for the switch() function:
  • Press Open the button section - Attribute Functions in the repository browser – a list of all attribute functions available in PhixFlow will appear
  • Double click on the entry for switch to bring up the help page
• Add an attribute to this stream to hold a description of the transaction type:
  • Name: TransactionTypeDesc

  • Expression: work out the transaction type description from TRANSACTION_TYPE, using a switch() statement, according to the rules below – use the examples in the help for switch() to get started

    TRANSACTION_TYPE	Description
    1	"Direct Debit"
    2	"Standing Order"
    3	"ePayment"
    4	"Cheque"
    Any other value	"Unknown"

    
    

• Run the stream and check that your translation of transaction type to transaction type description is correct

...