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

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.

Test Data.yxdb

Datasets

Reporting

Date Time

Accepted answers

davidskaife

Hi @akin_sony

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

Akin_Sony.yxmd

All comments

Qiu

@akin_sony
You mean generate rows for each day?

0926-akin_sony.yxzp

davidskaife

Hi @akin_sony

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

Akin_Sony.yxmd

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703