Hi All,
I am quite new to Alteryx and i would like some help me on converting weekly data to daily data and the final output should be daily data with the Average of Weekly sales and daily dates.
Input File:
| ID | Weekly Sales | Period Start Date | Period End Date |
| A | 322638.9 | 2013/01/12 | 2013/01/18 |
| B | 334155.8 | 2013/01/19 | 2013/01/25 |
| C | 442738.2 | 2013/01/26 | 2013/02/01 |
| D | 487107.3 | 2013/02/02 | 2013/02/08 |
| E | 484621.4 | 2013/02/09 | 2013/02/15 |
| F | 444071.5 | 2013/02/16 | 2013/02/22 |
| G | 401072.2 | 2013/02/23 | 2013/03/01 |
| H | 515085.5 | 2013/03/02 | 2013/03/08 |
| I | 583204.1 | 2013/03/09 | 2013/03/15 |
| J | 472802.9 | 2013/03/16 | 2013/03/22 |
| K | 345006.2 | 2013/03/23 | 2013/03/29 |
| L | 328326.3 | 2013/03/30 | 2013/04/05 |
| M | 358434.9 | 2013/04/06 | 2013/04/12 |
Expected Output:
Attached the spreadsheet for expected output and below are the variable name's explanation
1.Date: is the new column that has to be created with daily dates and
2.Variable Name: "Difference" is the difference between the Period Start Date & Period End Date.
3.Average Weekly Sales: is the (Weekly Sales/Difference).
Kindly help me in resolving this.
Thanks in Advance,
Vijay
