Skip to main content
Question

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

  • 21 February 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
You can set Fanout Dataset to Yes within the Advanced parameter settings of the writer and then fanout on the relevant attribute
There's more information on this technique here http://fmepedia.safe.com/articles/How_To/Fanout
Thank you!  Working great!

Reply