How to include all the dates within a date range

[lca50666]

How can I transform the table above into the format shown below?
I need to add the dates within the range and populate them with the same values.

[MartinDDDD]

Hey there,

you can use the Create Date&Time Range node to create the range based on start and end dates.

Once you have the range, you can add the columns UCL/LCL and pass in the values from your source data.

Note:

• it is important to first convert your dates from your string format to local date
• you grab the dates as variables using Table Column to variable. In my demo workflow the value at Row0 is always the start date
• You turn the first row of your source table into variables using Table Row to Variable Node so you can use UCL/LCL values as variables in constant Value Column nodes.

Here’s the prototype:
DateRngCreate.knwf (84.0 KB)