Skip to main content
Question

KML Writer with Attributes from Multiple Tables

  • March 29, 2013
  • 2 replies
  • 34 views

Hi.  I am using a SpatialFilter transformer to join two Oracle tables, and routing the result set to an Inspector and to a KML Writer.  The Inspector is correctly showing all wanted attributes from both tables (I am using AttributeKeepers to filter to only wanted attributes).  The KML Writer, however, is only showing the attributes for the parent table.  In the KML Writer, under Dynamic Properties, I am selecting both source schemas, so I'm unsure why the Writer is only showing the attributes from the parent schema.  Is there a way I can make the KML Writer show the attributes from both schemas (preferably without using an external .csv as I don't know whether I will have access to external files within a production mode). 

 

 

Thanks very much.

 

 

JR
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

fmelizard
Safer
Forum|alt.badge.img+21
  • Safer
  • March 29, 2013
Hi JR,

 

 

The results in the inspector can be tricky since they show the ffs file and its attributes, created to visualize the results.

 

 

If you are using dnamic referening both input tables and the results contain only attributes from one input, that usually means that the second input is not mapped.

 

 

In case of many base features it is better to use the spatial relator, creating a list of the related candidate features.

 

Exploding the list (list exploder) will return the related candidate features.

 

 

Hope this hepls.

 

 

 

 

  • Author
  • March 29, 2013
Thanks, Itay.  I will give the SpatialRelator transformer along with the ListExploder a try on Monday.  Sounds promising.

 

 

Thanks!

 

 

JR