Converting Weekly Data to Daily Data

[VijaySanthoshKumar]

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

[jdunkerley79]

Use a Generate Rows tool to make a set of dates.

I have attached a simple work book doing what I think you want. 

It is save in 10.5 if you have an older version can change file to be compatible!

[VijaySanthoshKumar]

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

[jdunkerley79 · Accepted solution]

Oops uploaded the wrong file!

Try this one!

[VijaySanthoshKumar]

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

[jdunkerley79]

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). 

[VijaySanthoshKumar]

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