Azure Data Explorer - Pivot Table

Hi,

In an IoT project we are gathering sensor data in Azure Data Explorer. All sensor data is stored in a "signals" table. To uniqely identify a timeseries for a given sensor, we query like this:

signals

| where TestId == "cbb8bff1-ee9d-4ead-bbd6-c9c246d84fd3" and SignalName == "Signal1"

We want to be able to Pivot all timeseries from a given TestId, from the "signals" Table Rows into Columns.

I have been unable to write a Kusto Query that Achieves this, and I am hoping for some help on this forum.

The current signals table schema looks like this:

I want to be able to Pivot the Table, to the following Schema

I have tried the following query:

let testId = "cbb8bff1-ee9d-4ead-bbd6-c9c246d84fd3";

signals

| where TestId == testId

| where SignalName == "Signal1" or SignalName == "Signal2" or SignalName == "Signal3"

| order by Timestamp desc

| evaluate pivot(SignalName)

But the resulting table, seems to repeat the timestamp - the timestamp is represented multiple times and a default value "0" is inserted in other signal columns:

I do not need to do any aggregation using the Pivot operator, since all Signals should have a value on the exact same timestamp.

• Can anyone help me writing a KQL query for this?

• Do I need to create a Materialized View in Azure Data Explorer to Achieve this? An update Policy or Function?

Thanks