I have the following database:
Table_source
ID,CATEGORY,TYPE,REMARK
1,TEST,TYPE 1,NO REMARK
What I need to do is export this to 2 XML files
Table_export_1
ID,CATEGORY
1,TEST
Table_export_2
ID,TYPE,REMARK
1,TYPE 1,NO REMARK
The problem is that I can't find how to do this, I've tried with a SchemaMapper, but I always get a 1:1 result instead of a 1:n result.
Can anyone help me out?
Thanks in advance.
It has be based on an external Excel or CSV, and the output should be multiple XML files.
+17
How about using two writers? Just branch the feature flow into two streams, and make each writer write required attributes only.
Takashi
+13
Yes Takashi's suggestion is the easiest and most efficient, its just a matter of removing/keeping the correspoinding attribues.
Itay
+13
+17
1. Create custom formats to extract schema subsets. Dynamic schema partial merge from 2 data sources http://fmepedia.safe.com/AnswersQuestionDetail?id=906a0000000cokTAAQ Extracting a schema subset for dynamic schemas http://fmepedia.safe.com/articles/How_To/Extracting-a-schema-subset-for-dynamic-schemas 2. Create tables defining schemas and use them as resources (similar to Itay's suggestion). Schema from Details Contained Within a Dataset (Example 3) in Dynamic Schema Examples http://fmepedia.safe.com/articles/Samples_and_Demos/Dynamic-Schema-Examples-FME2011 By the way, how do you determine which writer should be used to write the added attribute?
My idea was to use an Excel file with the mapping:
Source_feature,Target_feature,attribute,attribute_type
Table_source,Table_export_1,ID,fme_decimal(10,0)
Table_source,Table_export_1,CATEGORY,fme_varchar(30)
Table_source,Table_export_2,ID,fme_decimal(10,0)
Table_source,Table_export_2,TYPE,fme_varchar(30)
Table_source,Table_export_2,REMARK,fme_varchar(50)
Thus mapping the features and attributes. I don't have access to the target XML files, so I can't use them as a template. If the Excel changes, I'll receive a new one and I'll have to run the FME script again.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
