mnumber サンプル2
入力データ
| 顧客 | 来店日 | 生年月日 |
|---|---|---|
| customer1 | 19900115 | 19641222 |
| customer1 | 19900131 | 19641222 |
| customer1 | 19900521 | 19641222 |
| customer1 | 19900611 | 19641222 |
| customer2 | 19900122 | 19720103 |
| customer2 | 19900521 | 19720103 |
| customer2 | 19900801 | 19720103 |
| customer3 | 19910303 | 19720103 |
| customer4 | * | * |
| customer4 | 19900131 | * |
| customer4 | 19900610 | 19900618 |
| customer4 | 19900611 | 19900608 |
処理コマンド
mnumber key=0
結果データ
| 顧客 | 来店日 | 生年月日 | 連番 |
|---|---|---|---|
| customer1 | 19900115 | 19641222 | 1 |
| customer1 | 19900131 | 19641222 | 2 |
| customer1 | 19900521 | 19641222 | 3 |
| customer1 | 19900611 | 19641222 | 4 |
| customer2 | 19900122 | 19720103 | 5 |
| customer2 | 19900521 | 19720103 | 6 |
| customer2 | 19900801 | 19720103 | 7 |
| customer3 | 19910303 | 19720103 | 8 |
| customer4 | * | * | 9 |
| customer4 | 19900131 | * | 10 |
| customer4 | 19900610 | 19900618 | 11 |
| customer4 | 19900611 | 19900608 | 12 |