Mashup Macro - Add/Subtract/Multiply/Divide

View
Edit

Title: *

Vocabularies

Technology Tags:

Presto Tags:

Show summary in full view

Body:

This is a basic mashup macro that let's the user use a mathematical operator (add, subtract, multiply, divide) between a selected field from 2 mashup inputs. &nbsp;
The example below shows multiply. &nbsp;Modify the operator in this line for add, subtract, or divide: 'array[count][nodeName] = array[count][lhsVar] * array[count][rhsVar];'.

<pre>
&lt;macro name=&quot;Multiply&quot;>

&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&lt;input &nbsp; &nbsp;name=&quot;xmldoc&quot; type=&quot;document&quot;      />
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&lt;presto-meta name=&quot;macrotype&quot;>user&lt;/presto-meta>

&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&lt;input name=&quot;lhs&quot; type=&quot;string&quot; default=&quot;&quot;      />
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&lt;presto-meta name=&quot;type&quot; variable=&quot;lhs&quot; reference=&quot;xmldoc&quot;>datapath&lt;/presto-meta>
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&lt;presto-meta name=&quot;label&quot; variable=&quot;lhs&quot;>Field 1&lt;/presto-meta>

&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&lt;input name=&quot;rhs&quot; type=&quot;string&quot; default=&quot;&quot;      />
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&lt;presto-meta name=&quot;type&quot; variable=&quot;rhs&quot; reference=&quot;xmldoc&quot;>datapath&lt;/presto-meta>
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&lt;presto-meta name=&quot;label&quot; variable=&quot;rhs&quot;>Field 2&lt;/presto-meta>

&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&lt;input name=&quot;nodeName&quot; type=&quot;string&quot; default=&quot;Result&quot;      />
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&lt;output name=&quot;result&quot; type=&quot;document&quot;      />

&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&lt;variable name=&quot;repeatingElement&quot; type=&quot;string&quot; default=&quot;&quot;      />

&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&lt;namespaces>
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;namespace prefix=&quot;presto&quot; &nbsp;uri=&quot;java:com.jackbe.jbp.jems.client.EMMLPrestoFunctions&quot;      />
&nbsp;&nbsp; &nbsp; &nbsp; &lt;/namespaces>

&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&lt;assign outputvariable=&quot;repeatingElement&quot; fromexpr=&quot;presto:infergroupXPath($xmldoc)&quot;      />

&nbsp;&nbsp; &nbsp; &nbsp; &lt;if condition=&quot;$repeatingElement != '' &quot;>

&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;&quot;>
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;![CDATA[
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var array;
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var re = repeatingElement.substring(repeatingElement.lastIndexOf(&quot;/*:&quot;)+3);
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; eval('array = xmldoc..*::' + re);
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var count = 0;
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var lhsVar = lhs.substring(lhs.lastIndexOf(&quot;/*:&quot;)+3);
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var rhsVar = rhs.substring(rhs.lastIndexOf(&quot;/*:&quot;)+3);

&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for each(var record in array){
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(array[count].name().uri){
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; default xml namespace = array[count].name().uri;
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; array[count][nodeName] = array[count][lhsVar] * array[count][rhsVar];
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; count++;
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; result = xmldoc;
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ]]>
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&lt;/script>&nbsp;

&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;else> &nbsp; &nbsp;&nbsp;
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;assign fromvar=&quot;xmldoc&quot; outputvariable=&quot;result&quot; />
&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/else>
&nbsp;&nbsp; &nbsp; &nbsp; &lt;/if>
&lt;/macro>
 </pre>

Please ensure that code samples are placed within code tags to ensure the correct display <code></code>

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
Lines and paragraphs break automatically.
You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.

Full HTML

Web page addresses and e-mail addresses turn into links automatically.
Lines and paragraphs break automatically.

More information about formatting options

Audience:

Show this post in these groups.

Template settings

Mashup Macro - Add/Subtract/Multiply/Divide

Featured Community Member

Featured Mashup

Featured Idea