Delen via

make_set() (aggregatiefunctie)

  • Artikel

Van toepassing op: ✅Microsoft Fabric✅Azure Data Explorer✅Azure Monitor✅Microsoft Sentinel-

Hiermee maakt u een dynamic matrix van de set afzonderlijke waarden die expr in de groep opneemt.

Null-waarden worden genegeerd en worden niet meegenomen in de berekening.

Notitie

Deze functie wordt gebruikt in combinatie met de operator summarize.

afgeschafte aliassen: makeset()

Syntaxis

make_set( expr [,maxSize])

Meer informatie over syntaxisconventies.

Parameters

Naam Type Vereist Beschrijving
expr- string ✔️ De expressie die wordt gebruikt voor de aggregatieberekening.
maxSize int Het maximum aantal geretourneerde elementen. De standaard- en maximumwaarde is 1048576.

Notitie

De afgeschafte versie heeft een standaardversie maxSize limiet van 128.

Retourneert

Retourneert een dynamic matrix van de set afzonderlijke waarden die expr in de groep opneemt. De sorteervolgorde van de matrix is niet gedefinieerd.

Fooi

Als u alleen afzonderlijke waarden wilt tellen, gebruikt u dcount() of count_distinct().

Voorbeeld

Instellen vanuit een scalaire kolom

In het volgende voorbeeld ziet u de set statussen gegroepeerd met dezelfde hoeveelheid bijsnijdschade.

StormEvents 
| summarize states=make_set(State) by DamageCrops

De weergegeven resultatentabel bevat alleen de eerste 10 rijen.

Schadecrops Staten
0 ["NORTH CAROLINA","MINNESIN","NEW YORK","ALASKA","CAROLINA","INDIANA","INDIANA","ILLINOIS","MINNESOTA","SOUTH CAROLINA","TEXAS","UTAH","COLORADO","VERMONT","NEW JERSEY","VIRGINIA","CALIFORNIA","PENNSYLVANIA","MONTANA","WASHINGTON","OREGON ","HAWAII","IDAHO","PUERTO RICO","MICHIGAN","FLORIDA","WYOMING","GOLF VAN MEXICO","NEVADA","TENNESSEE","KENTUCKY","TENNESSEE","TENNESSEE","TENNESSEE","ALABAMA","GEORGIA","SOUTH CAROLINA","OHIO","NEW MEXICO","ATLANTIC SOUTH","NEW HAMPSHIRE","ATLANTIC NORTH","NORTH DAKOTA","IOWA","NEBRASKA","WEST VIRGINIA","MARYLAND","KANSAS","MISSOURI","ARKANSAS","ARIZONA","MASSACHUSETTS","MAINE","CONNECTICUT","GUAM""HAWAII WATERS","AMERICAN SAMOA","LAKE HURON","DISTRICT OF COLUMBIA","RHODE ISLAND","LAKE MICHIGAN","LAKE SUPERIOR","LAKE ST CLAIR","LAKE ERIE","LAKE ONTARIO","E PACIFIC","GULF OF ALASKA"]
30000 ["TEXAS","NEBRASKA","IOWA","MINNESOTA","OREGONIN"]
4000000 ["CALIFORNIË","KENTUCKY","NORTH DAKOTA","KENTUCKIN","VIRGINIA"]
3000000 ["CALIFORNIË","ILLINOIS","MISSOURI","SOUTH CAROLINA","NORTH CAROLINA","TENNESSEE","NORTH CAROLINA","NORTH CAROLINA","OHIO"]
14000000 ["CALIFORNIË","NORTH DAKOTA"]
400000 ["CALIFORNIË","MISSOURI","IOWA","NEBRASKA","MISSOURIIN","NORTH DAKOTA"]
50000 ["CALIFORNIË","GEORGIA","NEBRASKA","TEXAS","WEST VIRGINIA","KANSAS","MISSOURI","IOWA","NEW MEXICO","IOWA","NORTH CAROLINA","OHIO","KENTUCKIN","ILLINOIS","MINNESOTA","KENTUCKY"]
18000 ["WASHINGTON","MINNESIN"]
107900000 ["CALIFORNIË"]
28900000 ["CALIFORNIË"]

Instellen vanuit matrixkolom

In het volgende voorbeeld ziet u de set elementen in een matrix.

datatable (Val: int, Arr1: dynamic)
[
    1, dynamic(['A1', 'A2', 'A3']), 
    5, dynamic(['A2', 'C1']),
    7, dynamic(['C2', 'A3']),
    5, dynamic(['C2', 'A1'])
] 
| summarize Val_set=make_set(Val), Arr1_set=make_set(Arr1)
Val_set Arr1_set
[1,5,7] ["A1","A2","A3","C1","C2"]

Verwante inhoud