Skip to main content
Question

Help extracting text from an XML. I am confused about using XMLXQueryExtractor.

  • July 20, 2022
  • 1 reply
  • 74 views
C

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.

1 reply

debbiatsafe
Safer
Forum|alt.badge.img+22

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.

Community Stats

32,742
Posts
124,181
Replies
41,241
Members
Terms & ConditionsAccessibility statement
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.