Question

Creating a list from an attribute

  • 6 November 2019
  • 2 replies
  • 1 view

Badge
I have created an attribute from a database table for planning applications and this ultimately will populate an excel spreadsheet.

My question is in the excel spreadsheet it is coming though with the code of the different application types and for the audience that the spreadsheet is intended for it would make more sense to have the description pulled through.

i.e in the spreadsheet it is showing as ADV and i would like to convert this to advertisement consent


2 replies

Userlevel 1
Badge +21

You can use an AttributeValueMapper to do this. If you already have the Codes and Descriptions in a csv or similar you can populate this automatically using the import button

Badge

If you have translation table (e.g. a table or a csv) with a list of the codes with their corresponding descriptions you can use a FeatureJoiner or a FeatureMerger to pick the description from this table and put it on the features from the main source.

In this way your workspace won't have to change when your input data changes.

Reply