グループ式および集計式に指定した条件に従って、入力データをshunanalyzeコマンドを使って集計します。
集計コマンドの概要を以下に示します。
図5.6 集計コマンドの概要
入力データ例
入力データの例を以下に示します。
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 |
