Copy Keys

Copies the value of a source key to the destinations value

The Copy Keys action copies the value of a source key to the destinations value.. When applied to your processing rule, the Copy Keys action will copy the value of the source key of each record and replace it with the destination key of the same record.

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 copy the values from the user_id key to the page_id key for each record, from the actions drop down menu of your processing rules tab, select Copy keys. In the Source Key text box, add “user_id,” and in the Destination Key text box, add “page_id.” If `regexMode` is set, `src` is treated as a regular expression and `dst` as a substitution pattern. Then click apply.

Your processing rule will now replace the value for page_id for every record, with the value of user_id of the same record. Now the values of user_id and page_id are the same for each record.

\

Last updated