azure-data-explorer - Kusto 仅投影非空值或删除具有空值的列

Question

当我查询时，我得到一行，其中包含多个空值。有没有办法在结果中不获取空值，或者删除具有空值的列？

示例代码为:

let table_name = datatable(name:string, date_part:datetime, job_1:string, job_2:string, job_3:string, job_4:string)
[
     "David", datetime(2022-05-9), "Architect", "", "", "Engineer"
  
];
table_name 
|where name == "David" and (date_part  between (now() .. -10d))
|project  (job_1),(job_2),(job_3),(job_4)

谢谢!

Answer 1

let table_name = datatable(name:string, date_part:datetime, job_1:string, job_2:string, job_3:string, job_4:string)
[
     "David", datetime(2022-05-9), "Architect", "", "", "Engineer"
    ,"David", datetime(2022-05-6), "Musician", "Producer", "", ""
];
table_name 
| where name == "David" and (date_part  between (now() .. -10d))
| project-keep job_*
| evaluate narrow()
| where isnotempty(Value)
| evaluate pivot(Column, any(Value), Row)
| project-away Row

<表类=“s-表”><标题>job_1job_2job_4 <正文>建筑师工程师音乐家制作人

Fiddle