mage5 サンプル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 |
処理コマンド
mage5 field1=2 field2=3
結果データ
顧客 | 来店日 | 生年月日 | 年代 |
---|---|---|---|
customer1 | 19900115 | 19641222 | 25 |
customer1 | 19900131 | 19641222 | 25 |
customer1 | 19900521 | 19641222 | 25 |
customer1 | 19900611 | 19641222 | 25 |
customer2 | 19900122 | 19720103 | 15 |
customer2 | 19900521 | 19720103 | 15 |
customer2 | 19900801 | 19720103 | 15 |
customer3 | 19910303 | 19720103 | 15 |
customer4 | * | * | * |
customer4 | 19900131 | * | * |
customer4 | 19900610 | 19900618 | 0 |
customer4 | 19900611 | 19900608 | 0 |