Relative Content

Tag Archive for kqlazure-data-explorerkusto-explorer

ADX – KQL: Conditionally Extending Property Columns from Dynamic Column

let systems = datatable(traceName: string, trace: string) [ ‘Temp1’, ‘trace_1_temperature’, ‘Temp2’, ‘trace_2_temperature’, ‘Temp3’, ‘trace_3_temperature’ ]; let telemetry = datatable(timestamp: datetime, data: dynamic) [ datetime(2023-09-11T10:00:00Z), dynamic({‘trace_1_temperature’: 35, ‘trace_2_temperature’: 40, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:05:00Z), dynamic({‘trace_1_temperature’: 36, ‘trace_3_temperature’: 42, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:10:00Z), dynamic({‘trace_2_temperature’: 38, ‘trace_3_temperature’: 41, ‘voltage’:5, ‘active’:’true’}) ]; My desired output hardcoded for this case: let hardCodedDesiredOutput = […]

ADX – KQL: Conditionally Extending Property Columns from Dynamic Column

let systems = datatable(traceName: string, trace: string) [ ‘Temp1’, ‘trace_1_temperature’, ‘Temp2’, ‘trace_2_temperature’, ‘Temp3’, ‘trace_3_temperature’ ]; let telemetry = datatable(timestamp: datetime, data: dynamic) [ datetime(2023-09-11T10:00:00Z), dynamic({‘trace_1_temperature’: 35, ‘trace_2_temperature’: 40, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:05:00Z), dynamic({‘trace_1_temperature’: 36, ‘trace_3_temperature’: 42, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:10:00Z), dynamic({‘trace_2_temperature’: 38, ‘trace_3_temperature’: 41, ‘voltage’:5, ‘active’:’true’}) ]; My desired output hardcoded for this case: let hardCodedDesiredOutput = […]

ADX – KQL: Conditionally Extending Property Columns from Dynamic Column

let systems = datatable(traceName: string, trace: string) [ ‘Temp1’, ‘trace_1_temperature’, ‘Temp2’, ‘trace_2_temperature’, ‘Temp3’, ‘trace_3_temperature’ ]; let telemetry = datatable(timestamp: datetime, data: dynamic) [ datetime(2023-09-11T10:00:00Z), dynamic({‘trace_1_temperature’: 35, ‘trace_2_temperature’: 40, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:05:00Z), dynamic({‘trace_1_temperature’: 36, ‘trace_3_temperature’: 42, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:10:00Z), dynamic({‘trace_2_temperature’: 38, ‘trace_3_temperature’: 41, ‘voltage’:5, ‘active’:’true’}) ]; My desired output hardcoded for this case: let hardCodedDesiredOutput = […]

ADX – KQL: Conditionally Extending Property Columns from Dynamic Column

let systems = datatable(traceName: string, trace: string) [ ‘Temp1’, ‘trace_1_temperature’, ‘Temp2’, ‘trace_2_temperature’, ‘Temp3’, ‘trace_3_temperature’ ]; let telemetry = datatable(timestamp: datetime, data: dynamic) [ datetime(2023-09-11T10:00:00Z), dynamic({‘trace_1_temperature’: 35, ‘trace_2_temperature’: 40, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:05:00Z), dynamic({‘trace_1_temperature’: 36, ‘trace_3_temperature’: 42, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:10:00Z), dynamic({‘trace_2_temperature’: 38, ‘trace_3_temperature’: 41, ‘voltage’:5, ‘active’:’true’}) ]; My desired output hardcoded for this case: let hardCodedDesiredOutput = […]

ADX – KQL: Conditionally Extending Property Columns from Dynamic Column

let systems = datatable(traceName: string, trace: string) [ ‘Temp1’, ‘trace_1_temperature’, ‘Temp2’, ‘trace_2_temperature’, ‘Temp3’, ‘trace_3_temperature’ ]; let telemetry = datatable(timestamp: datetime, data: dynamic) [ datetime(2023-09-11T10:00:00Z), dynamic({‘trace_1_temperature’: 35, ‘trace_2_temperature’: 40, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:05:00Z), dynamic({‘trace_1_temperature’: 36, ‘trace_3_temperature’: 42, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:10:00Z), dynamic({‘trace_2_temperature’: 38, ‘trace_3_temperature’: 41, ‘voltage’:5, ‘active’:’true’}) ]; My desired output hardcoded for this case: let hardCodedDesiredOutput = […]