mweek サンプル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 |
処理コマンド
mweek field=2
結果データ
顧客 | 来店日 | 生年月日 | 週番(来店日) | 週番開始日付(来店日) |
---|---|---|---|---|
customer1 | 19900115 | 19641222 | 2 | 19900114 |
customer1 | 19900131 | 19641222 | 4 | 19900128 |
customer1 | 19900521 | 19641222 | 20 | 19900520 |
customer1 | 19900611 | 19641222 | 23 | 19900610 |
customer2 | 19900122 | 19720103 | 3 | 19900121 |
customer2 | 19900521 | 19720103 | 20 | 19900520 |
customer2 | 19900801 | 19720103 | 30 | 19900729 |
customer3 | 19910303 | 19720103 | 61 | 19910303 |
customer4 | * | * | * | * |
customer4 | 19900131 | * | 4 | 19900128 |
customer4 | 19900610 | 19900618 | 23 | 19900610 |
customer4 | 19900611 | 19900608 | 23 | 19900610 |