Jump to content

Creating rows based on row/cell data.

Bernardo Garcia Jr

Recommended Posts

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

Link to comment
Share on other sites

  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...