Interstage Data Effector ユーザーズガイド

5.4.1 条件に一致するデータを集計する

グループ式および集計式に指定した条件に従って、入力データをshunanalyzeコマンドを使って集計します。

集計コマンドの概要を以下に示します。

[図：集計コマンドの概要]

入力データ例

入力データの例を以下に示します。

Schema.csv

"Kbn","Number","Kname","Nname","Val"

Data.csv

"B","200","ni-hyaku","suzuki","700"

"C","301","san-hyaku-ichi","tanaka","500"

"B","201","ni-hyaku-ichi","gotou","600"

"A","100","hyaku","yamada","900"

"C","300","san-hyaku","imai","600"

"A","101","hyaku-ichi","satou","800"

◆出力データ例

出力データの例を以下に示します。

Output.csv

"Kbn","Number","Kname","Nname","ValSUM","ValMAX","CT"

"A","100","hyaku","yamada",900,900,1

"A","101","hyaku-ichi","satou",800,800,1

"A","-","hyaku","yamada",1700,900,2

"B","200","ni-hyaku","suzuki",700,700,1

"B","201","ni-hyaku-ichi","gotou",600,600,1

"B","-","ni-hyaku","suzuki",1300,700,2

"C","300","san-hyaku","imai",600,600,1

"C","301","san-hyaku-ichi","tanaka",500,500,1

"C","-","san-hyaku","imai",1100,600,2

"-","-","hyaku","yamada",4100,900,6