Filling in Years even without data

Hi Community,

I'm trying to generate tables according to my data with Macro and App set up. Everything is fine, but the output is skipping "Final Close Years" that do not have any data (e.g. It's missing Year 2011). I know I need to use "Generate Rows" tool and i'm not sure how to. Please enlighten me!

Thanks!

Workflow

Accepted answers

Yes so basically Row+1:Year gives me year in next row. And at the last year there is no next year so current [Year]+1 so support row generate tool.

The above issue might be occurring because your column name is Final Close Years and my column name is year

I have renamed to match yours it should work now.

Hope this helps 🙂

All comments

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Hi @atcodedog05, thanks for replying!

This seems would work, but i'm not sure how to incorporate it into my macro here. Should I union join that with my Summarize tool in the middle?

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15872

MarqueeCrew 13708

apathetichell 13703