Create New Array by Appending Expressions

Create a new flat array by appending new expressions using the array:append() function

Query

logscale

array:append(array="related.user[]", values=[lower(source.user.name), lower(destination.user.name)])

Introduction

The array:append() function can be used to create a new array based on values from an array of expressions, provided that the input array has continuous, sequential indexes with no missing indexes.

In this example, the array:append() function is used to create a new array related.user[] containing information about all user names seen on the event.

Example incoming data might look like this:

source.user.name="user_1" destination.user.name="USER_2"

Step-by-Step

Starting with the source repository events.
flowchart LR; %%{init: {"flowchart": {"defaultRenderer": "elk"}} }%% repo{{Events}} 0[\Add Field/] result{{Result Set}} repo --> 0 0 --> result style 0 fill:#ff0000,stroke-width:4px,stroke:#000;
logscale
```
array:append(array="related.user[]", values=[lower(source.user.name), lower(destination.user.name)])
```
Creates a new array related.user[] containing information about all user names seen on the event. Notice that the lower() function formats the results into lower case before appending them to the array.
Event Result set.