...
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
...
...
...
...
...
...
...
...
...
...
- Press the button in the left-hand menu bar of PhixFlow – a list of all attribute functions available in PhixFlow will appear
- Double-click on the entry for switch to bring up the help page
...
...
TRANSACTION_TYPE | Description |
1 | "Direct Debit" |
2 | "Standing Order" |
3 | "ePayment" |
4 | "Cheque" |
Any other value | "Unknown" |
...
- Create an aggregate stream, with name Bank Account Summary
- Add a pipe from the stream you created in the previous exercise (this is probably called SOURCE_BANK_ACCOUNT_TRANS) to Bank Account Summary
- Add to the pipe the grouping:
- ACCOUNT_NUM
- Drag the attribute ACCOUNT_NUM into Bank Account Summary from either the pipe or the input stream
- Add an attribute:
- Name: TotalPosTrans
- Type: Float
- Expression: using a forEach loop, add up the total of all positive transcations, and store it in this attribute
- Run Bank Account Summary to test this new attribute
- When this is working, update TotalPosTrans to also calculate the total of negative transcations, and the total of all transcations – and hold them in local variables ($variables)
- Add two further attributes – TotalNegTrans and TotalTrans - that allow you to store the values of all negative and all transcations that you calculated in TotalPosTrans
- Run Bank Account Summary again to test the new attributes
By the end of this chapter you will be able to:
- Use the switch() function
- Use the forEach() function
...
- Press the button in the left-hand menu bar of PhixFlow – a list of all attribute functions available in PhixFlow will appear
- Double-click on the entry for switch to bring up the help page
...
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
...
...
...
...
...
...
...
...
...
...
...
...