Generate Missing Rows and add Nulls

[Scraps822]

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.

[gc]

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

[Scraps822]

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.

[Joe_Mako · Accepted solution]

How about the attached?

[SeanAdams]

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