I have an XML attribute containing metadata of a large number of tables. For each table I want to search through the metadata and extract the table name, all of its attributes, and the attribute descriptions. Each table has a varying number of attributes. Once I have the values want to print them clearly on a Word document where the table name is at the top of the page with all of the attributes listed below.
Userlevel 3
+17
- Safer
- 590 replies
-
21 July 2022
Hello @connornew
Since you have multiple tables in the XML, you may want to consider using the XMLFragmenter (simpler) or XMLXQueryExploder (more advanced) before the XMLXQueryExtractor. This should create one feature per table and should help when creating the Word document downstream.
If you're having trouble with using the XQuery, please post a sample of the dataset.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.