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
Solved! Go to Solution.
Hi jdunkerley79,
Thank you so much for the immediate response.
is it possible for you to share the input file "Breadown 52535" that you have used for converting weekly data to daily data, a sample will also do.
I am finding little difficult in understanding the workflow.
Regards,
Vijay
Hi jdunkerley79,
i am getting an error "Error: Generate Rows (182): The value did not change after the Loop Expression."
and in Generate Rows Tool may i know what this expression means Left(DateTimeAdd([Date],1,"days"),10)
I am guessing, in the field date add 1 day to the period start date,but May i know what that '10' refers. Does this loop works only for 10 rows?
if yes,then in case if i have 1000 rows or incrementing rows, how can i automate it?
Thanks in Advance,
Vijay
The DateTimeAdd function returns a DateTime rather than a Date
The Left(..., 10) truncates the time part off to convert back to a Date.
The input to the Generate Rows need to be Dates (i.e. yyyy-MM-dd format). If other format (your sample had yyyy/MM/dd) you will need to reformat to be dates (I had a multifield formula in the sample).
Yes, I forgot about the MultiField Formula, now it works without any error.
Thank you for your help and for your immediate response jdunkerley79
Regards,
Vijay