Copy row where where condition is true

I'd drawing a blank on this task and want to use Generate Rows tool but not sure it's the right one!

My data is in the first table. Where campaign = 1 I want to duplicate that row but add a week onto the date, giving table 2.

Can someone point me in the right direction please?

W/E	Product	Campaign	W/E	Product	Campaign
13/11/2019	A	0	13/11/2019	A	0
13/11/2019	B	0	13/11/2019	B	0
13/11/2019	C	1	13/11/2019	C	1
13/11/2019	D	0	20/11/2019	C	1
			13/11/2019	D	0

Help

Accepted answers

tonypreece

Am I allowed to solve my own problem?!!! It became obvious right after I posted the question.

All comments

tonypreece

Am I allowed to solve my own problem?!!! It became obvious right after I posted the question.

Claje

While this is probably possible using only a generate rows tool, I think that is a relatively complex design. I instead set this up using a Generate Rows, Formula, and Select tool.

Take a look at the attached and let me know if you have any questions!

claje_NewRowDateAdd.yxmd

Jonathan-Sherman

Hi @tonypreece,

I believe this is what you're trying to achieve? I've used the generate rows tool.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workbook for you to download if needed.

Regards,

Jonathan

20191127 - GenerateRows.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703