Skip to main content
Question

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

  • February 21, 2013
  • 3 replies
  • 12 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

3 replies

ebygomm
Influencer
Forum|alt.badge.img+32
  • 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+21
  • 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!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings