StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>These are the steps I would take to achieve this - it'll have to be a high level description of a solution as you haven't included any schema definition or Xml sample.</p> <p>You can use XSLT or The Mapping Designer to do this. I describe the latter;</p> <p>1) Use the <code>Logical Existence</code> Functoid to Check if the Address 2 node exists. It return True if Address 2 is present in your source schema.</p> <p>2) Connect the <code>Logical Existence</code> functoid to a <code>Value Mapping</code> functoid (as the first input) and drag the Address 2 value to the same (as your second input).</p> <p>3) Connect the <code>Value Mapping</code> Functoid to the Address Destination node.</p> <p>4) Next, you need to cater for non-existent Address 2's. So, add a Logical Not functoid to your mapper surface.</p> <p>5) Connect the <code>Logical Not</code> to you <code>Logical Existence</code>. This reads "Not Exists".</p> <p>6) Connect your <code>Logical Not</code> to Another <code>Value Mapping</code> Functoid as the First input.</p> <p>7) Connect your Address 1 value to the <code>Value Mapping</code> functoid as your second input.</p> <p>8) Connect the Second <code>Value Mapping</code> to the Address Destination.</p> <p>So, you should have two connections to the destination node but only one path with be true, resulting in one mapping.</p> <p>Hope this gives you a guide on how to approach this. Shout if you need more help!</p> <p>EDIT: Heres an illustration to help!</p> <p><img src="https://i.stack.imgur.com/JPVjJ.png" alt="enter image description here"></p> <p>TJ</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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