/
15 Creating and using macros
15 Creating and using macros
By the end of this chapter you will be able to:
- Create macros
- Use macros
Creating macros
- Find in the repository Macros
- Right-click and select Add Macro
- Configure the macro:
- Name:
NumOfWeeks
- Minimum Parameters:
2
- Maximum Parameters:
2
- Expression: create an expression to work out the number of weeks - as a whole number – between two dates
- Use the functions dateDiff() and round() to help with this
- Name:
- Press to save your new macro OK
Using Macros
- Create a new model:
Try Macros
- Drag the table
MC Macro Terminated Customers
on to your model- This contains some key dates for terminated customers: the signup date; the date that the customer terminated their service; the date that the final debt on the customer's account was cleared
- Add attributes for:
- the number of weeks between signup and termination
- the number of weeks between termination and the final debt being cleared
- In each case, use your macro to calculate the number of weeks between the two dates
- Run the table
MC Macro Terminated Customers
to test your new attributes
Related content
9 Filtering Table Output
9 Filtering Table Output
Read with this
15 Creating and using macros
15 Creating and using macros
More like this
14 Attribute Scripting
14 Attribute Scripting
Read with this
15 Creating and using macros
15 Creating and using macros
More like this
Understanding Data Types
Understanding Data Types
Read with this
15 Creating and using macros
15 Creating and using macros
More like this