Interstage Data Effector ユーザーズガイド

4.5.3.2 見出し行(項目名)の異なるCSVファイルをソートする場合

入力ファイルに、項目数、項目順が統一されていない複数のCSVファイルを指定できます。項目名が同じものを同一項目として扱い、合わせてソートを実行します。
項目数、項目順が統一されていない複数のCSVファイルを入力する場合、リターン式を指定する必要があります。

■入力ファイル1

"Rcode","Rname","Scode","Sname","Sales","Location","Size"

"001","東京","1002","渋谷店","3000","繁華街","150"

"004","神奈川","4001","川崎店","5000","駅ビル","120"

"002","千葉","2002","浦安店","2000","駅ビル","137"

"002","千葉","2001","船橋店","1500","モール","215"

"001","東京","1006","品川店","5000","駅中","90"

■入力ファイル2

"Scode","Sname","Sales","Rcode","Rname","Employees","parking"

"3001","大宮店","3000","003","埼玉","8","○"

"1004","新宿店","9000","001","東京","12","×"

"4002","横浜店","8000","004","神奈川","10","○"

■入力ファイル3

"Scode","Sname","Sales"

"1001","東京店","12000"

"3002","浦和店","2000"

■ソート条件ファイル

ソート式  : $Rcode, val($Sales) DESC

リターン式: $Rcode, $Rname, $Sales, $Sname

■ソート結果イメージ

"Rcode","Rname","Sales","Sname"

"001","東京","9000","新宿店"

"001","東京","5000","品川店"

"001","東京","3000","渋谷店"

"002","千葉","2000","浦安店"

"002","千葉","1500","船橋店"

"003","埼玉","3000","大宮店"

"004","神奈川","8000","横浜店"

"004","神奈川","5000","川崎店"

,,"12000","東京店"

,,"2000","浦和店"