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 compare rows based on groups of data within a column

J Zhou

Recommended Posts

How do you add a calculated column that identifies within the same groups of [WheelsetNumber], there is differing [W05Wheelset] values within the rows

E.g. WheelsetNumber 100009 has KCLASS and GSHORT strings, I'd like it to return '1'. As opposed to 100920, where I want it to return '0' as all rows for 100920 have the same KCLASS strings in the [W05Wheelset] column. For wheelset numbers with one row, such as 100011, I want it to return '0' as well

I know I need to use a mixture of OVER functions but I'm out of my depth. Any help appreciated :)

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