Bagikan melalui

make_set() (aggregation function)

  • Artikel

Berlaku untuk: ✅Microsoft Fabric✅✅

dynamic Membuat array dari sekumpulan nilai berbeda yang diambil expr dalam grup.

Nilai null diabaikan dan tidak memperhitungkan perhitungan.

Catatan

Fungsi ini digunakan bersama dengan ringkasan operator.

Alias yang tidak digunakan lagi: makeset()

Sintaks

make_set( expr [,maxSize])

Pelajari selengkapnya tentang konvensi sintaksis.

Parameter

Nama Tipe Wajib Deskripsi
expr string ✔️ Ekspresi yang digunakan untuk perhitungan agregasi.
maxSize int Jumlah maksimum elemen yang dikembalikan. Nilai default dan maks adalah 1048576.

Catatan

Versi yang tidak digunakan lagi memiliki batas maxSize default 128.

Mengembalikan

Mengembalikan dynamic array dari sekumpulan nilai berbeda yang diambil expr dalam grup. Urutan sortir larik tidak ditentukan.

Tip

Untuk hanya menghitung nilai yang berbeda, gunakan dcount() atau count_distinct().

Contoh

Mengatur dari kolom skalar

Contoh berikut menunjukkan kumpulan status yang dikelompokkan dengan jumlah kerusakan pemangkasan yang sama.

StormEvents 
| summarize states=make_set(State) by DamageCrops

Tabel hasil yang ditampilkan hanya menyertakan 10 baris pertama.

DamageCrops status
0 ["NORTH CAROLINA","WISCONSIN","NEW YORK","ALASKA","DELAWARE","OKLAHOMA","INDIANA","ILLINOIS","MINNESOTA","SOUTH DAKOTA","TEXAS","UTAH","COLORADO","VERMONT","NEW JERSEY","VIRGINIA","CALIFORNIA","PENNSYLVANIA","MONTANA","WASHINGTON",""CALIFORNIA", OREGON","HAWAII","IDAHO","PUERTO RICO","MICHIGAN","FLORIDA","WYOMING","TELUK MEKSIKO","NEVADA","LOUISIANA","LOUISIANA ","TENNESSEE","KENTUCKY","MISSISSIPPI","ALABAMA","GEORGIA","SOUTH CAROLINA","OHIO","NEW MEXICO","ATLANTIC SOUTH","NEW CAROLINA","NEW CAROLINA","OHIO","NEW MEXICO","ATLANTIC SOUTH","NEW CAROLINA","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","Teluk ALASKA"]
30000 ["TEXAS","NEBRASKA","IOWA","MINNESOTA","WISCONSIN"]
4000000 ["CALIFORNIA","KENTUCKY","NORTH DAKOTA","WISCONSIN","VIRGINIA"]
3000000 ["CALIFORNIA","ILLINOIS","MISSOURI","SOUTH CAROLINA","NORTH CAROLINA","MISSISSIPPI","NORTH DAKOTA","OHIO"]
14000000 ["CALIFORNIA","NORTH DAKOTA"]
400000 ["CALIFORNIA","MISSOURI","MISSISSIPPI","NEBRASKA","WISCONSIN","NORTH DAKOTA"]
50000 ["CALIFORNIA","GEORGIA","NEBRASKA","TEXAS","WEST VIRGINIA","KANSAS","MISSOURI","MISSISSIPPI","NEW MEXICO","IOWA","NORTH DAKOTA","OHIO","WISCONSIN","ILLINOIS","MINNESOTA","KENTUCKY"]
18000 ["WASHINGTON","WISCONSIN"]
107900000 ["CALIFORNIA"]
28900000 ["CALIFORNIA"]

Mengatur dari kolom array

Contoh berikut menunjukkan sekumpulan elemen dalam array.

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"]

Konten terkait