...
- 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 the
button in the hover menu so that the stream attributes are automatically configured
- Open the help for the switch() function:
- Press the button
in the left-hand menu bar of CenterView PhixFlow – a list of all attribute functions available in CenterView PhixFlow will appear - Double-click on the entry for switch to bring up the help page
- Press the button
- 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
...