Page Comparison

Existing lookups required

To perform these operations, it is necessary to have existing lookups ready for use (visit this article to get help uploading lookups and this article to get help creating query lookups).

Syntax special considerations

• Status
  title "lookup_name"

  → This must be the name of lookup that contains the data you want to use to enrich your data. The name of an inexistent lookup will return an error when running the query.

• Status
  colour Blue title key_field

  → This must be the table field that will be used to correlate with the lookup key. The name can be different than the lookup key field as long as the data type coincide and the values it contains are potential matches (username-user). The absence of matches will return null and a different data type will return an error when running the query .

• Status
  colour Green title timestamp_field

  → This must be the table timestamp that will be used to correlate with the lookup timestamp. A data type other than timestamp will return an error when running the query.