Generate Missing Rows and add Nulls

Hi Everyone,

So I've been looking around trying to figure it out. I just can't get anywhere with Generate Rows. So here is the task. In the file we have

Test 1 has minimum at -26 and max at 16 in Weeks to Release.

Test 2 has minimum at -4 and max at 11 in Weeks to Release.

I want to be able to add rows for Test 2 that will go down to -26 and up to week 16. In each row I want the Survey Movie to still say Test 2, add a row for each Awareness and Interest metric and Percent of Total to be Null for the added weeks but keep the values for when we do have data.

I'm just having issues figuring it out.

Thanks in advance.

Test data for alteryx.xlsx

Preparation

Accepted answers

How about the attached?

generate missing.png

generate missing.yxmd

All comments

Maybe this Knowledge Base article would help, if you haven't come across it already?

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-to-use-the-Generate-Rows-tool-to-fill-in-missing-months/ta-p/25860

I saw this. I've been playing around with it. Maybe I'm missing a step because I can't get to work. thank you.

How about the attached?

generate missing.png

generate missing.yxmd

Hey @Scraps822 - did this get you to a solution?

If so - would you mind marking this one as closed - if not, happy to iterate with you to get to a solution together.

Thanks @Scraps822

Sean

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703