How to Create Year loop in Inline Table

[vidyasagar159]

Hi All,

Hope you are doing great. I want to create a Year Loop in my InLine Table from 1985 to Current Year. Can some please share me your thoughts on this. I really appreciate your help.

Thanks,

-Vidya

[dplr-rn]

What do you mean by year loop?
Automatically create list of year s?
If so Inline is not the answer. You need to use autogenerate for that. Refer a master calendar script to get the idea

[MarcoWedel]

can you post your inline table and your expected result?

[sunny_talwar · Accepted solution]

May be like this

LOAD 1985 + IterNo() - 1 as Year
AutoGenerate 1
While  1985 + IterNo() - 1 <= Year(Today());

[vidyasagar159]

Thanks a lot, Sunny. This is exactly what I am looking for.