Skip to main content
  • EN
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


Community Stats

30,078
Posts
114,188
Replies
37,705
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.