Skip to content

Adding Data

The "Append Data" tool is similar to a SQL LEFT OUTER JOIN.

The Input List corresponds to the left table in a LEFT OUTER JOIN. All records from it are written to the output file unless the setting "Remove from output lines that don't match any item from the Append List" is enabled. If this setting is enabled, the result becomes an INNER JOIN.

The Append List corresponds to the right table in a SQL LEFT OUTER JOIN.

In the Append Criteria, you must specify the columns in both the input and append lists that are used to join the two lists. Two join conditions are supported:

  • "matches text" — values in the corresponding columns in both lists are identical.
  • "matches IP range" — the value in the input list column is an IP address that falls within a range defined by two columns in the append list (start and end of the range).

Both the input and append lists must be sorted by the columns used for joining. To automatically sort the lists in the correct order, enable the "Sort/De-Dup First" setting.

You can specify which columns to select from both the input and append lists (column numbers separated by commas), as well as the delimiter: TAB or COMMA.

Input list rows that do not match any row in the append list can be written to a separate file (File Containing Lines That Don't Match Any Item From The Append List).

Example

Input List:

aaa@dmain.com,A1
bbb@domain.com,A2
ccc@dmain.com,A3
ddd@domain.com,A4
eee@dmain.com,A5
fff@domain.com,A6

Append List:

ddd@domain.com,B1
eee@dmain.com,B2
fff@domain.com,B3
ggg@dmain.com,B4
hhh@domain.com,B5
iii@domain.com,B6

Append Criteria: Input Field 1 matches text 1

Output File:

aaa@dmain.com,A1
bbb@domain.com,A2
ccc@dmain.com,A3
ddd@domain.com,A4,ddd@domain.com,B1
eee@dmain.com,A5,eee@domain.com,B2
fff@domain.com,A6,fff@domain.com,B3