Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Fill Down or Repeat field through join

flipperdm
8 - Asteroid

Hi,

I'm having difficulty finding anything even close to my desired solution to this through the discussions so I'll try a new topic.

 

I have a table contains a "week number" field, indicating when a fruit is first put into a zone

 

clipboard_image_5.png

 

I need to fill the missing weeks that occur between the zone changes, but not to exceed the earliest week number but can go as high as I limit (in this case, week 20).  This would repeat the zone until it changes.  What tool or logic would I use to create this data?

 

clipboard_image_6.png

 

 

2 REPLIES 2
geraldo
13 - Pulsar

Hi,

 


A very quick suggestion might be this
Use the Generate rows tool and formula tool

 

follow the setting

 

 

 

clipboard_image_1.png

 

 

clipboard_image_2.png

 

 

[]

flipperdm
8 - Asteroid

Perfect.  I can also add a filter to eliminate any weeks that are over 52.  Thank you much!

Labels