make_set() (aggregation function)
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
- sekilas jenis fungsi Agregasi sekilas
make_set_if
make_list
- make_bag() (fungsi agregasi)
mv-expand