Skip to main content
Solved

Work with codelists/picklists/KVP as attributes

  • November 3, 2014
  • 4 replies
  • 37 views
G
Hello all!

 

 

I think it's a very fundamental question and yet, I didn't find anything about that topic on the net:

 

I have a lot of different feature-types defined in an Oracle DB and several attributes of this feature (i.e. construction_type) are set via codelists. Meaning in the feature-table there is a column construction_type_cl_id, in the codelist itself there is the corresponding id and a text-value for the construction_type.

 

 

I should transform this schema into another one, without this codelists.

 

 

My question now: How can I check for certain ids in the codelists, get the corresponding string, and then based on that string search for another id in a different codelist for to reclassify the features?

 

 

Thanks in advance for any input!

 

 

Regards

 

Markus

Best answer by gio

Sounds like a look-up table to me.

 

 

You can do this in sql with a sub-query, inline query or a with select statement.
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.

4 replies

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • Best Answer
  • November 3, 2014
Sounds like a look-up table to me.

 

 

You can do this in sql with a sub-query, inline query or a with select statement.
G
  • geom
  • Author
  • November 4, 2014
Thanks Gio! Exactly what I was looking for - didn't know FME had such strong integration of SQL...
david_r
Celebrity
  • david_rCelebrity
  • November 4, 2014
Hi,

 

 

in particular, look at the Joiner (http://docs.safe.com/fme/html/FME_Transformers/Default.htm#Transformers/joiner.htm) transformer. If you can use it in conjunction with an exhaustive prefetch query it can be very fast (even faster than the SQLExecutor since it can cache the whole result set into memory).

 

 

David
G
  • geom
  • Author
  • November 6, 2014
Thanks, David for your input as well! I will play around with the Joiner too.

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.