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

Last Operating Date


malak rihaili

Recommended Posts

Presumably you have a date column I am not completely clear how you wish the result to be.

 

Something like this would give you a date and it would be set for every row to the maximum value of [YOURDATE] for each [W_GNR_NAME] when

 is 10.

If [code] is never 10 then it is null for that well.

 

Max(case when [code]='10' then [YOURDATE] end) over ([W_GNR_NAME]

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