concat

The concat function joins two or more strings together into a single string.

Spec

concat(arg0, arg1, ...)

Parameters

arg0, arg1, ... - The strings to concatenate.

Return Value

A single string containing all input strings joined together.

Example

datatable(a:string, b:string)[
    "Hello", "World"
]
| extend combined = concat(a, " ", b)

a	b	combined
Hello	World	Hello World

Concatenate multiple columns:

datatable(x:string, y:string, z:string)[
    "A", "B", "C"
]
| extend result = concat(x, y, z)

x	y	z	result
A	B	C	ABC

concat

Concatenates strings.

Syntax

concat(String1, String2, [, StringN])

Examples

Concatenate host and path:

requests
| project url = concat(host, path)
| take 5

Build a label:

metrics
| project label = concat(service, ":", instance)