KQL条件子查询

Question

你好，我在互联网上的朋友们，
我想显示行，条件是它们不能以其他方式出现在其他行上
例如，我有一张表：

AbbyOK[/tr>

姓名		状态
Abby	Abbson	OK
Bobby	Bobson	不正常
Sandra	Mayer

在这种情况下，您只需要验证一个人是否没有OK记录。

datatable(Name:string,LastName:string,Status:string)
[
"Abby"  ,"Abbson" ,"OK"
,"Abby"  ,"Abbson" ,"Not OK"
,"Bobby" ,"Bobson" ,"Not OK"
,"Sandra","Mayer"  ,"OK"
]
| summarize countif(Status == "OK") by Name, LastName
| where countif_ == 0

姓名		countif_
Bobby	Bobson	0

这行得通吗？

datatable (Name: string, LastName: string, Status: string) [
"Abby","Abbson","OK",
"Abby","Abbson","Not OK",
"Bobby","Bobson","Not OK",
"Sandra","Mayer","OK"
]
| summarize make_set(Status) by Name, LastName
| where array_index_of( set_Status,"Not OK") >= 0 and array_length( set_Status) == 1

名称	LastName	设置状态
鲍比