Skip to main content
Question

Add unique key

  • April 6, 2020
  • 5 replies
  • 186 views

Forum|alt.badge.img

Hello

I want to create or add a unique key to a row after an transformer like a primary key in a database table just before updated my data. Did you know how to realize this operation ?

 

thanks

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.

5 replies

redgeographics
Celebrity
Forum|alt.badge.img+59
  • Celebrity
  • 3700 replies
  • April 6, 2020

The easiest way to do that would be a Counter, which simply counts each feature passing through and assigns it that value.


Forum|alt.badge.img
  • Author
  • 27 replies
  • April 6, 2020

Ok. I understood this counter could create a sequence number. But, I think I misspoke , I can't to add this key on my row.

single key + data ==> single key | data

What is the correct design workflow to do this operation ?


redgeographics
Celebrity
Forum|alt.badge.img+59
  • Celebrity
  • 3700 replies
  • April 6, 2020
You can then use an AttributeManager to add that unique key you just made to an existing attribute value.

Forum|alt.badge.img
  • Author
  • 27 replies
  • April 6, 2020
how to call a sql function which calculates a field from the attribute manager?

nampreetatsafe
Safer
Forum|alt.badge.img+13
how to call a sql function which calculates a field from the attribute manager?

Hi @jerome: If I understand your question, I don't think you necessarily need SQL.  I think this video tutorial will help demonstrate how/where you can leverage existing fields/attributes to calculate another field/attribute.  Hope this helps!