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

Adding Row

JBartzsch
5 - Atom

I would like to add an additional row (Vintage) where there is a gap in the year that has a count value of 0, so that the data is chronological without gaps. Ideally, I would like to do this in every instance the gap potentially would occur.

Currently the data reads:

1994 - 2

1996 - 5

1997 - 4

 

Goal:

1994 - 2

1995 - 0

1996 - 5

1997 - 4

JBartzsch_0-1603460805530.png

 

Any solutions would be appreciated!

3 REPLIES 3
Emil_Kos
17 - Castor
17 - Castor

Hi @JBartzsch,

 

There are probably various ways to approach your problem. I have used to generate rows.

 

Emil_Kos_0-1603461177351.png

The output:

 

Emil_Kos_1-1603461193924.png

 

 

If you need less/more years you need to change generate rows configuration. Now it starts in 1994 and the max year is 2022

 

Emil_Kos_2-1603461233350.png

 

 

Emil_Kos
17 - Castor
17 - Castor

Hi @JBartzsch,

 

Thank you for marking my answer as a solution.

 

Good luck with your work!

JBartzsch
5 - Atom

@Emil_Kos This will work perfect, thank you!

Labels