mnumber サンプル1
入力データ
顧客 | 来店日 | 生年月日 |
---|---|---|
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=1
結果データ
顧客 | 来店日 | 生年月日 | 連番 |
---|---|---|---|
customer1 | 19900115 | 19641222 | 1 |
customer1 | 19900131 | 19641222 | 2 |
customer1 | 19900521 | 19641222 | 3 |
customer1 | 19900611 | 19641222 | 4 |
customer2 | 19900122 | 19720103 | 1 |
customer2 | 19900521 | 19720103 | 2 |
customer2 | 19900801 | 19720103 | 3 |
customer3 | 19910303 | 19720103 | 1 |
customer4 | * | * | 1 |
customer4 | 19900131 | * | 2 |
customer4 | 19900610 | 19900618 | 3 |
customer4 | 19900611 | 19900608 | 4 |