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. In the processing rules tab, in the Actions dropdown, select Allow records.

2. In the Key field, enter action.

3. In the Regex field, enter purchase.

4. Optional: Select the Match case checkbox if you want your regular expression to be case-sensitive.

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.