2.x
Ask or search…
K

Allow Records

Remove all records with a key that do not match a regular expression
The Allow Records action removes all records with a key that doesn't match a regular expression. When applied to your processing rule, the Allow Record action allows only records that match the provided regular expression.
For example, given the following sample website log data:
{"timestamp":"2023-03-28T09:08:41.64283645Z","user_id":3,"page_id":30,"action":"purchase"}
{"timestamp":"2023-03-28T09:08:42.643343109Z","user_id":4,"page_id":10,"action":"purchase"}
{"timestamp":"2023-03-28T09:08:48.643600498Z","user_id":1,"page_id":50,"action":"click"}
{"timestamp":"2023-03-28T09:08:50.643773688Z","user_id":5,"page_id":40,"action":"purchase"}
{"timestamp":"2023-03-28T09:08:51.643932272Z","user_id":1,"page_id":30,"action":"purchase"}
{"timestamp":"2023-03-28T09:08:56.644080944Z","user_id":2,"page_id":40,"action":"click"}
{"timestamp":"2023-03-28T09:09:03.64425954Z","user_id":3,"page_id":30,"action":"click"}
{"timestamp":"2023-03-28T09:09:03.644317046Z","user_id":1,"page_id":20,"action":"view"}
{"timestamp":"2023-03-28T09:09:10.64447719Z","user_id":2,"page_id":50,"action":"purchase"}
{"timestamp":"2023-03-28T09:09:17.644810963Z","user_id":2,"page_id":10,"action":"view"}
{"timestamp":"2023-03-28T09:09:20.644994805Z","user_id":1,"page_id":50,"action":"view"}
To allow only records which have the value purchase for the action key:
  1. 1.
    In the processing rules tab, in the Actions dropdown, select Allow records.
  2. 2.
    In the Key field, enter action.
  3. 3.
    In the Regex field, enter purchase.
  4. 4.
    Optional: Select the Match case checkbox if you want your regular expression to be case-sensitive.
  5. 5.
    Click Apply.
Allow Records Processing Rule action
Your processing rule will now allow only those records with the value of purchase for the action key in your pipeline.