Generating a Calendar Day List with Dynamic Price Information Based on Input File

[matheusld2]

Hello,

I have a file that contains the pricing of three different products according to the deadline, as follows:

The output must be the list of all calendar days between days 1 and 360, filled with price information provided in the input file. The value must be repeated in the output according to the "boundaries" defined in the input file. For example, from days 1 to 7, the values must match the value defined for the 7th day in the input file. The same goes for the 8th to the 14th, the 15th to the 30th, etc. The desired output should look like this: 

Any ideas on how to achieve this? 

Thanks in advance for the help! 

[gawa]

hi @matheusld2 

In case of increasing rows dynamically, Generate Row toll would help like this.