Skip to main content
Question

Creating one xml file per feature (row in Oracle database)

  • February 21, 2013
  • 3 replies
  • 36 views

I have a workspace that reads an Oracle database table and creates an xml document.  I would like to create one xml document per row in the table and name that xml document based on the value of an attribute.

 

 

I was able to accomplish this by using a parameter and referencing the parameter in the reader "sql where clause" and in the textline writer dataset name.  But this approach requires me to execute the transform externally for each row in the database.

 

 

Sorry for the remedial questions - I know I am just missing some basics...

 

 

Thank you in advance.

 

 

SS
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.

3 replies

ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • February 21, 2013
You can set Fanout Dataset to Yes within the Advanced parameter settings of the writer and then fanout on the relevant attribute

davideagle
Contributor
Forum|alt.badge.img+22
  • Contributor
  • February 21, 2013
There's more information on this technique here http://fmepedia.safe.com/articles/How_To/Fanout

  • Author
  • February 21, 2013
Thank you!  Working great!