Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><strong>This transformation</strong>:</p> <pre><code>&lt;xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"&gt; &lt;xsl:output omit-xml-declaration="yes" indent="yes"/&gt; &lt;xsl:variable name="vNames" select= "tokenize(unparsed-text('file:///c:/temp/delete/Names.txt'), '\s')"/&gt; &lt;xsl:variable name="vDoc1" select="document('file:///c:/temp/delete/FileA.xml')"/&gt; &lt;xsl:variable name="vDoc2" select="document('file:///c:/temp/delete/FileB.xml')"/&gt; &lt;xsl:template match="/"&gt; &lt;t&gt; &lt;xsl:sequence select= "$vDoc1/*/*[@name = $vNames], $vDoc2/*/*[not(@name = $vNames)] "/&gt; &lt;/t&gt; &lt;/xsl:template&gt; &lt;/xsl:stylesheet&gt; </code></pre> <p><strong>when applied on any XML document (not used) and having these two files</strong>:</p> <p><strong>c:/temp/delete/FileA.xml</strong>:</p> <pre><code>&lt;t&gt; &lt;data name="name1"&gt; &lt;value&gt;abc1&lt;/value&gt; &lt;/data&gt; &lt;data name="name2"&gt; &lt;value&gt;abc2&lt;/value&gt; &lt;/data&gt; &lt;data name="name3"&gt; &lt;value&gt;abc3&lt;/value&gt; &lt;/data&gt; &lt;/t&gt; </code></pre> <p><strong>c:/temp/delete/FileB.xml</strong>:</p> <pre><code>&lt;t&gt; &lt;data name="name1"&gt; &lt;value&gt;xyz1&lt;/value&gt; &lt;/data&gt; &lt;data name="name2"&gt; &lt;value&gt;xyz2&lt;/value&gt; &lt;/data&gt; &lt;data name="name3"&gt; &lt;value&gt;xyz3&lt;/value&gt; &lt;/data&gt; &lt;/t&gt; </code></pre> <p><strong>c:/temp/delete/Names.txt</strong>:</p> <pre><code>name1 name3 </code></pre> <p><strong>produces the wanted, correct result:</strong></p> <pre><code>&lt;t&gt; &lt;data name="name1"&gt; &lt;value&gt;abc1&lt;/value&gt; &lt;/data&gt; &lt;data name="name3"&gt; &lt;value&gt;abc3&lt;/value&gt; &lt;/data&gt; &lt;data name="name2"&gt; &lt;value&gt;xyz2&lt;/value&gt; &lt;/data&gt; &lt;/t&gt; </code></pre> <p><strong>Explanation</strong>:</p> <p>Proper use of the standard XSLT functions: <strong><a href="http://www.w3.org/TR/xslt20/#function-unparsed-text" rel="nofollow"><code>unparsed-text()</code></a></strong> (2.0 and up only) and <strong><a href="http://www.w3.org/TR/1999/REC-xslt-19991116#function-document" rel="nofollow"><code>document()</code></a></strong> and the standard XPath 2.0 function <strong><a href="http://www.w3.org/TR/xpath-functions/#func-tokenize" rel="nofollow"><code>tokenize()</code></a></strong></p>
    singulars
    1. This table or related slice is empty.
    1. POHow do I selectively include elements from one or the other xml file based on the contents of a plain text file?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDimitre Novatchev
    1. USDimitre Novatchev
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I selectively include elements from one or the other xml file based on the contents of a plain text file?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COthanks. Saxon is giving this error: "NotSpecified: (No source file name:String) [], RemoteException". Also, my xml files have other elements in that I want reproduced in the output (they are the same in file 'a' and file 'b'), will this approach still work in that case? (and sorry if that was vital info I should have put in the question)
      singulars
      1. PO
      1. This table or related slice is empty.
    2. CO@JackDouglas, If you simply create the files with the given filepaths and filenames and run this transformation with Saxon 9 (or any other compliant XSLT 2.0 processor), you must get the same result that I got (using Saxon 9.1.07) and copied and pasted the result in this answer. As for having new requirements that aren't specified in the question, I strongly recommend that you ask a new, separate question and describe them completely there. In its current form your question has been completely answered. The short answer is that any non-referenced element from FileB is copied to the output.
      singulars
      1. PO
      1. USDimitre Novatchev
    3. COI have done that (except changing the path names) and I get the same error—is it possibly because I'm using the .NET variant and you are using the Java variant? I don't know. I trust that it *is* working for you however, and I'm delighted because I've been able to adapt your answer to get what I want. Thanks a million!
      singulars
      1. PO
      1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload