appendToListIfNotExist

This operator appends the rows to the custom list that do not exist already.

Operator Usage in Easy Mode

1. Click + on the parent node.

2. Enter the Append To List If Not Existsoperator in the search field and select the operator from the Results to open the operator form.

3. In the Table drop-down, enter or select a table from which to source the data.

4. In the List Name drop-down, enter or select a name of the list to which you want to append the rows.

5. In the Columns drop-down, select columns on which the matching is to be performed to find the unique rows to be appended

6. Click Run to view the result.

7. Click Save to add the operator to the playbook.

8. Click Cancel to discard the operator form.

Usage Details

LQL Command

Input Parameters:
table: The table to append to the custom list
listName: The name of the custom list to which the rows are to be appended
columns: The columns on which the matching to be performed to find the unique rows to be appended

Output
Unique rows that are appended to the custom list