Skip to main content
Question

group by and assign value


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 .

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
david_r wrote:

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 :-)


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings