Skip to main content
  • EN
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
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.
Thanks Gio! Exactly what I was looking for - didn't know FME had such strong integration of SQL...
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
Thanks, David for your input as well! I will play around with the Joiner too.

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie settings
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.