ACL Scripting Guide 14.1

Combine data

The combine data commands provide several different ways for combining data inside Analytics.

For an overview of combing data in Analytics, see Combining data.

Command Description

APPEND

Combines records from two or more Analytics tables by appending them in a new Analytics table.

DEFINE RELATION

Defines a relation between two Analytics tables.

EXTRACT

Extracts data from an Analytics table and outputs it to a new Analytics table, or appends it to an existing Analytics table. You can extract entire records or selected fields.

FUZZYJOIN

Uses fuzzy matching to combine fields from two Analytics tables into a new, single Analytics table.

JOIN

Combines fields from two Analytics tables into a new, single Analytics table.

MERGE

Combines records from two sorted Analytics tables with an identical structure into a new Analytics table that uses the same sort order as the original tables.