Solved

How to Use Summary Output from Statistics Calculator as part of calculation

Forum|Forum|6 years ago
January 3, 2019
5 replies
322 views

katrinaopperman

Hello,

This should be a very simple thing, but I just can't figure out how to do it!

I want to append two tables together (Tables 1 & 2), both with very similar attributes, but I want to use the ID from Table 1 as the official Primary Key, and then get the highest number from that PK and increment upwards to create new PK values for the Table 2 appended values. I can get the maximum value from Table 1 using StatisticsCalculator, but I can't for the life of me work out how to use that value in the creation of the new Primary Key.

I've been trying to do a conditional value calculation in Attribute Manager, something like, if Table 1 ID has a value, then PK = Table 1 ID, else use MaxValue from StatisticsCalculator and sum it with @sum(@double(@Count()),1.0) to increment up. But it's not working.

Any ideas greatly appreciated!

Thank you!

Katrina

Best answer by mark2atsafe

I tried to make something and it came out pretty much like @itay and @gio said. StatisticsCalculator, FeatureMerger, Counter. Like this:

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

+18

itay
Supporter
Forum|Forum|6 years ago
January 3, 2019

Hi @katrinaopperman,

If what you require is an increment on the highest value from table 1 ( max value from statistics calculator) then you can use a Counter to add to that value.

Alternatively if you are writing to a database, you can set up a sequence on the database starting from the max value and let de database take care of the PK increment.

Hope this helps,

Itay