Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

How to make a summary table to a day level table


Woody Wu

Recommended Posts

I have a summray table with the startand end dates of all the jobs as below:

job name start date end date

JobA 02/21/21 02/28/21

job B 01/23/21 01/28/21

How can I convert the summary table to a day level table with a "status" columnin which it would show "yes" if the date in "date" column arebetween start and end date in the summary table:

job name date status

Job A 02/20/21 no

job A 02/21/21 yes

job A 02/22/21 yes

....

job A 02/28/21 yes

job A 03/01/21 yes

Thanks,

Link to comment
Share on other sites

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...