How do you generate rows of data for missing week numbers?

Question

Hello,

I have a query that pulls in 14 days worth of data. There are associated week numbers, for this situation 34,35,36. However, in some cases, there is only data for one or two weeks but not all three. I would like to capture the week numbers that have data but also generate one row for the weeks that have none.

For example, if week 35 has data I would like to pull in that as normal but generate two rows that show week 34 and 36 with nulls in every other column. I have tried the multi row tool but to no luck. Any help would be much appreciated.

Alteryx Help.xlsx

AdwaitTarudkar · Answer

Sample input data-

Sample output data-

Recipe-

(select only the week number column and apply the multiple row tool to generate missing week number/s, then left join back to original data to identify a new entry in the week number row and then union back to original data to get rest fields as null)

I hope this helps!

Qiu · Answer

@RazorbackFan96 
I am sorry but I was not able to fully understand.
Can you give a sample output?

RazorbackFan96 · Answer

Pull in 3 week numbers regardless of data or not every time but make week numbers with no data null.