Skip to main content
Question

Creating a list from an attribute

  • November 6, 2019
  • 2 replies
  • 87 views

Forum|alt.badge.img
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

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

ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • November 6, 2019

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


Forum|alt.badge.img
  • November 6, 2019

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.