print operator
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Outputs a single row with one or more scalar expression results as columns.
Syntax
print [ColumnName =] ScalarExpression [, ...]
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| ColumnName | string |
The name to assign to the output column. | |
| ScalarExpression | string |
✔️ | The expression to evaluate. |
Returns
A table with one or more columns and a single row. Each column returns the corresponding value of the evaluated ScalarExpression.
Examples
The examples in this section show how to use the syntax to help you get started.
The examples in this article use publicly available tables in the help cluster, such as the
StormEventstable in the Samples database.
The examples in this article use publicly available tables, such as the
StormEventstable in the Weather analytics sample data.
Print sum and variable value
The following example outputs a row with two columns. One column contains the sum of a series of numbers and the other column contains the value of the variable, x.
print 0 + 1 + 2 + 3 + 4 + 5, x = "Wow!"
Output
| print_0 | x |
|---|---|
| 15 | Wow! |
Print concatenated string
The following example outputs the results of the strcat() function as a concatenated string.
print banner=strcat("Hello", ", ", "World!")
Output
| banner |
|---|
| Hello, World! |