Interstage Data Effector ユーザーズガイド

4.4.3.1 集計結果をCSV形式で出力する場合

集計結果は、グループ式と集計式に指定した順に出力します。
グループ式でグループ化の階層を指定した場合、グループ単位の集計結果を先に出力します。すべての入力データを集計した結果は、最後に出力します。
1レコードの項目は、以下の順に出力します。

1. グループ式で指定された項目
2. 集計式で指定された項目

■入力ファイル

"Kbn","Kname","Number","Nname","Code","Name","Val"

"01","設備","1000","第一開発部","AAA","ブロックＡ","1000"

"01","設備","1000","第一開発部","BBB","ブロックＢ","1200"

"01","設備","1000","第一開発部","CCC","ブロックＣ","800"

"02","事務","1000","第一開発部","AAA","ブロックＡ","500"

"02","事務","1000","第一開発部","BBB","ブロックＢ","200"

"01","設備","1001","第二開発部","AAA","ブロックＡ","100"

"01","設備","1001","第二開発部","BBB","ブロックＢ","500"

"02","事務","1001","第二開発部","AAA","ブロックＡ","5000"

"02","事務","1001","第二開発部","BBB","ブロックＢ","3200"

"01","設備","1002","第三開発部","AAA","ブロックＡ","1500"

"01","設備","1002","第三開発部","BBB","ブロックＢ","1000"

"02","事務","1002","第三開発部","AAA","ブロックＡ","1520"