mpaste サンプル1
入力データ
| 日付 | 品名 | 個数 | 単価 |
|---|---|---|---|
| 19961011 | computer | 1 | 50000 |
| 19961011 | computer | 2 | 23000 |
| 19961011 | monitor | 1 | 4500 |
| 19961025 | monitor | 1 | 4500 |
| 19961025 | monitor | 5 | 3000 |
| 19961025 | HDD | * | 4500 |
| 19961025 | HDD | 5 | 3000 |
dat.2
| 日付 | 顧客 | 個数 | 粗利 |
|---|---|---|---|
| 19960115 | customer1 | 1 | 150 |
| 19960115 | customer2 | 2 | -10 |
| 19960115 | customer3 | 1 | -45 |
| 19960707 | customer2 | 1 | 10 |
| 19960707 | * | 4 | * |
| 19961010 | customer4 | * | -100 |
| 19961010 | customer5 | 5 | 150 |
処理コマンド
mpaste file=dat.2
結果データ
| 日付 | 品名 | 個数 | 単価 | 日付 | 顧客 | 個数 | 粗利 |
|---|---|---|---|---|---|---|---|
| 19961011 | computer | 1 | 50000 | 19960115 | customer1 | 1 | 150 |
| 19961011 | computer | 2 | 23000 | 19960115 | customer2 | 2 | -10 |
| 19961011 | monitor | 1 | 4500 | 19960115 | customer3 | 1 | -45 |
| 19961025 | monitor | 1 | 4500 | 19960707 | customer2 | 1 | 10 |
| 19961025 | monitor | 5 | 3000 | 19960707 | * | 4 | * |
| 19961025 | HDD | * | 4500 | 19961010 | customer4 | * | -100 |
| 19961025 | HDD | 5 | 3000 | 19961010 | customer5 | 5 | 150 |