# KTHLARGESTIF 函式

`KTHLARGESTIF` 計算作業會透過套用至群組的條件進行篩選。

## 基本用法

`pivot value: KTHLARGESTIF(POS_Sales, 1, DayOfWeek == 'Saturday') group:storeNbr limit:1`

## 語法

`pivot value:LISTIF(col_ref, limit, test_expression) [group:group_col_ref] [limit:limit_count]`

col_ref字串為您要求取值的資料欄提供來源資料。
k_integer整數別要從來源資料欄中擷取出來的值排名
test_expression字串用來求取值的運算式，必須解析為 `true``false`

### k_integer

• `k=1` 代表資料欄的最大值。
• 如果 k 大於或等於資料欄中的值數目，則會傳回最小值。
• 遺漏值或空值不會列為 `k` 範圍的計算因子。

## 範例

### 範例：特定城市的第二大測量值

datecityrain_cmtemp_Cwind_mph
1/23/17Valleyville0.0012.86.7
1/23/17Center Town0.319.45.3
1/23/17Magic Mountain0.000.07.3
1/24/17Valleyville0.2517.23.3
1/24/17Center Town0.541.17.6
1/24/17Magic Mountain0.325.08.8
1/25/17Valleyville0.023.36.8
1/25/17Center Town0.833.35.1
1/25/17Magic Mountain0.59-1.76.4
1/26/17Valleyville1.0815.04.2
1/26/17Center Town0.966.17.6
1/26/17Magic Mountain0.77-3.93.0
1/27/17Valleyville1.007.22.8
1/27/17Center Town1.3220.00.2
1/27/17Magic Mountain0.775.65.2
1/28/17Valleyville0.12-6.15.1
1/28/17Center Town0.145.04.9
1/28/17Magic Mountain1.501.10.4
1/29/17Valleyville0.3613.37.3
1/29/17Center Town0.756.19.0
1/29/17Magic Mountain0.603.36.0

`pivot value:KTHLARGESTIF(rain_cm,2,city == 'Center Town') limit:1`

`pivot value:KTHLARGESTIF(temp_C,2,city == 'Center Town') limit:1 `

`pivot value:KTHLARGESTIF(wind_mph,2,city == 'Center Town') limit:1 `

### 傳送您對下列選項的寶貴意見...

Google Cloud Dataprep 說明文件