How we can split dataset into multiple datasets where each dataset has 1 date. And save each dataset in one file distinct
Input:
| BuyDate | Value |
|---|---|
| 01/10/1996 | 55254 |
| 01/10/1996 | 45543 |
| 01/10/1996 | 45353 |
| 02/12/2012 | 78878 |
| 02/12/2012 | 65725 |
| 01/05/2013 | 78675 |
| 01/05/2013 | 42432 |
| 01/05/2013 | 78686 |
Output expected:
Dataset 1:
| BuyDate | Value |
|---|---|
| 01/10/1996 | 55254 |
| 01/10/1996 | 45543 |
| 01/10/1996 | 45353 |
Dataset 2:
| BuyDate | Value |
|---|---|
| 02/12/2012 | 78878 |
| 02/12/2012 | 65725 |
Dataset 3:
| BuyDate | Value |
|---|---|
| 01/05/2013 | 78675 |
| 01/05/2013 | 42432 |
| 01/05/2013 | 78686 |
