时间戳

首页 > 解决方案 > Kusto：如何将列表列转换为行

kql - Kusto：如何将列表列转换为行

问题描述

我在表列类型中有一列是字符串。

["2021-03-18T08:49:08.4670000Z","2021-03-18T13:41:59.3230000Z","2021-03-18T13:46:59.2390000Z","2021-03-18T15:00:13.1960000Z","2021-03-18T16:19:47.0000000Z","2021-03-18T16:26:49.8480000Z","2021-03-18T17:06:49.7910000Z","2021-03-18T18:19:44.8760000Z","2021-03-18T19:34:44.8710000Z","2021-03-18T19:48:01.7160000Z","2021-03-18T20:23:01.6540000Z","2021-03-18T20:56:49.7960000Z","2021-03-18T22:21:49.7880000Z","2021-03-18T23:44:47.6500000Z","2021-03-19]

我想将此列表保存为行；喜欢：

Start_time
2021-03-18T08:49:08.4670000Z
2021-03-18T13:41:59.3230000Z
2021-03-18T13:46:59.2390000Z

我尝试了几件事，但它不会工作。

标签： kql

解决方案

你应该把它变成动态的并使用 mv-expand：

datatable(Values:string)['["2021-03-18T08:49:08.4670000Z","2021-03-18T13:41:59.3230000Z","2021-03-18T13:46:59.2390000Z","2021-03-18T15:00:13.1960000Z","2021-03-18T16:19:47.0000000Z","2021-03-18T16:26:49.8480000Z","2021-03-18T17:06:49.7910000Z","2021-03-18T18:19:44.8760000Z","2021-03-18T19:34:44.8710000Z","2021-03-18T19:48:01.7160000Z","2021-03-18T20:23:01.6540000Z","2021-03-18T20:56:49.7960000Z","2021-03-18T22:21:49.7880000Z","2021-03-18T23:44:47.6500000Z","2021-03-19"]']
| extend Values =todynamic(Values)
| mv-expand Values to typeof(datetime)

请注意，您示例中的最后一个值缺少结束 qoute。作为旁注，最好首先将列键入为动态。

推荐阅读