Home
Developer Guides
Macros for HCL Unica
Macros can be used in Unica Campaign and Unica Interact to enhance your flowcharts.
Using Macros in Unica Campaign
This chapter provides usage information about Unica Campaign macros. Be sure to read this chapter before you attempt to use macros in Unica Campaign.
Macro function summaries for Campaign
The tables in this section summarize the macro functions by category.
Grouping Functions

Developer Guides
- Validation PDK Guide
- Macros for HCL Unica
  Macros can be used in Unica Campaign and Unica Interact to enhance your flowcharts.
  - Using Macros in Unica Campaign
    This chapter provides usage information about Unica Campaign macros. Be sure to read this chapter before you attempt to use macros in Unica Campaign.
    - Macro function summaries for Campaign
      The tables in this section summarize the macro functions by category.
    - Macro function parameters for Campaign
      This section describes the parameters and usage for macro functions in Unica Campaign.
    - Using Custom DB Function
  - Using macros in Unica Interact
    This chapter provides usage information about Unica Interact macros. Be sure to read this chapter before you attempt to use macros in Unica Interact.
  - Macros Reference
    This section describes each available macro that is available for use in Campaign, Interact, or both. Macros are listed in alphabetical order.

Grouping Functions


Macro Name	Returns	Description
`GROUPBY`	One new column with a value for each row	Summarizes across multiple rows of data within a group
`GROUPBY_WHERE`	One new column with a value for each row	Summarizes across multiple rows of data that meet a specified condition and are within a group

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.