如何在Kusto的数据表创建中使用用户定义的标量

Question

基本上，我想定义一个标量，然后在数据表中使用该标量。比如:

let dayOne = "Day One";
let dayTwo = "Day Two";
let dayStringMapping = datatable(Batch: int64, BatchDay: string)
[   
01, dayOne,
02, dayTwo
];

我该怎么做?

Answer 1

datatable运算符需要常量标量值作为输入。

另一种方法是使用print运算符。

如果需要，您可以union多个使用print操作符生成的行。

例如:

let dayOne = "Day One";
let dayTwo = "Day Two";
let dayStringMapping = 
union (print Batch = 1, BatchDay = dayOne),
(print Batch = 2, BatchDay = dayTwo);
... do something with 'dayStringMapping' ...