Generate rows with daily data, and taking original dataset and splitting out by the days

[akin_sony]

Hi All,

I'm trying to convert this data I have to a daily level, by diving each row data by the number of days between the Start Date and the End Date apart from one column which I'd like to keep constant [Ad played to: 100%].

Ideally for the first row I'll have data for each day between the 3rd of July and 10th of July all on separate rows.

[Qiu]

@akin_sony 
You mean generate rows for each day?

[davidskaife · Accepted solution]

Hi @akin_sony 

It's a bit rough but is this what you're looking for?

[akin_sony]

Hi @davidskaife This is exactly what I'm looking for

Thank you! I'm curious to know what the find and replace is actually doing though?

[davidskaife]

Hi @akin_sony 

I'm using it in a similar fashion to a vlookup; appending the Count field to all instances where the Campaign Name field matches between the main data stream and the summerise tool. You could do it as a Join but this way shouldn't create duplicated rows