Addition, sum, plus / Concatenation (add, +)

[ 1 Description ] [ 2 How does it work in the search window? ] [ 3 How does it work in LINQ? ]

Description

Adds a new column that returns the addition or concatenation of the given elements. Depending on the input data types, this operation can be used in different ways:

Addition of two or more numbers (float or integer). This operation returns a float or integer.
Addition of two or more duration fields. This operation returns a duration.
Addition of a timestamp and a duration. This operation returns a timestamp.
Concatenation of two or more strings. This operation returns a string.

How does it work in the search window?

Select Create column in the search window toolbar, then select the Addition, sum, plus / Concatenation operation. You need to specify at least two arguments:

Argument	Data type

Argument

Data type

Add / Concat ^mandatory

The name of the first argument changes depending on the data type selected as input:

Add → float, integer, timestamp, duration
Concat → string

plus ^mandatory

float, integer, timestamp, duration, string

Depending on the data type chosen in the first argument, different data types are allowed here. See the possible combinations in the above section.

If you select a float, integer, duration or string value in the first argument, you can add as many plus arguments as required.

The data type of the new column values can be float, integer, duration, timestamp, or string, depending on the arguments selected (see above the different combinations and output data types).

Example

In the demo.ecommerce.data table, we want to add 300 to all the values in the bytesTransferred column. To do it, create a new column using the Addition, sum, plus / Concatenation operation. Let's call the new column bytesTransferred+300

The arguments needed to create the new column are:

Add - bytesTransferred column
plus - Click the pencil icon and enter 300

Click Create column and you will see the following result:

How does it work in LINQ?

Use the operator select... as... and add the operation syntax to create the new column. These are the valid formats of the Addition, sum, plus / Concatenation operation:

number1 + number2 +...
duration1 + duration2 +...
timestamp + duration
string1 + string2 +...
add(number1, number2,...)
add(duration1, duration2,...)
add(timestamp, duration)
add(string1, string2,...)

Example

You can copy the following LINQ scripts and try the above example on the demo.ecommerce.data table.

from demo.ecommerce.data
  select bytesTransferred + 300 as `byesTransferred+300`

or

from demo.ecommerce.data
  select add(bytesTransferred, 300) as `bytesTransferred+300`