Skip to main content
Question

group by and assign value

  • June 1, 2016
  • 2 replies
  • 14 views

gis2020
Contributor
Forum|alt.badge.img+5

Hi , i have table where the name are in two languages and there is another field/ column (sn_grp) with some values calculated only for one language so now i want to calculate that value for other language where the name and ID's are same .

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.

2 replies

david_r
Celebrity
  • June 1, 2016

Hi

You could use a Sorter to sort by ID (ascending) and sn_grp (descending). Then use an AttributeCreator to replace NULL values with the value from the preceeding feature:

For the value of sn_grp, use a conditional to test if a value is already present (do nothing) or if it is undefined (use the value from the preceeding feature):

David


gis2020
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • June 1, 2016

Hi

You could use a Sorter to sort by ID (ascending) and sn_grp (descending). Then use an AttributeCreator to replace NULL values with the value from the preceeding feature:

For the value of sn_grp, use a conditional to test if a value is already present (do nothing) or if it is undefined (use the value from the preceeding feature):

David

Thank you david ..it worked :-)