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

Only performing update operation once key changes


Recommended Posts

This has been driving me nuts trying to figure this out. I have data that looks somewhat like this:

 

Company A

Company A

Company A

Company A

Company B

Company B

Company C

 

I am using SUMROWS to "total" how many are in each. However, as I step through the Data I end up with this:

 

1

2

3

4

1

2

1

 

I need to put the total (4, 2 and 1) into another field. But how do I stop it updating until I have that total (i.e. when the company is changing I don't want to perform 7 updates, I only want to perform 3. As it is I do an update for every source row I have. Yes I get the correct results at the end, but it's a lot of overhead.

 

I am using the Scribe adapter for Dynamics 365 so I am unable to query the database directly with SQL (I'd love to just do a simple SQL with a group by)

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