Creating rows based on row/cell data.

[Bernardo Garcia Jr]

I have two columns: start and end date. I am trying to create one row for each month between start and end date inclusive. In excel Power Query I can use the list.expand function to this row creation.

For example,

September 2019 - Start Date

November 2019 - End Date

So the row should expand and copy all data for September, October, and November.

How do I acheive the same results in Spotfire Do I need to use Python or R code as part of a data function

[Khushboo Rabadia]

You can look at the data function in this article:

https://support.tibco.com/s/article/How-to-create-a-continuous-date-rang...

[Bernardo Garcia Jr]

Thank you.  That worked.