Differences

This shows you the differences between two versions of the page.

--- pub:conditionalmap [2014/03/26 11:22] – created ken
+++ pub:conditionalmap [2014/03/26 11:41] – ken
@@ Line 29: / Line 29: @@
 </pre></html>
-  * ** *CURROW**: Specify the current row.
+* **If the value in column x to column y**: Map this field only if the values specified exist in the columns specified, otherwise the field does not map.
+<html>
+<table width="30%" style="border: 1px dotted gray; margin-left: 20px;">
+<tr><th colspan="3">Mapped Field Conditional Tests</th></tr>
+<tr><td width="10%">&nbsp;</td><td>&#061;</td><td>equal to</td></tr>
+<tr><td width="10%">&nbsp;</td><td>&lt;&#061;</td><td>less than or equal to</td></tr>
+<tr><td width="10%">&nbsp;</td><td>&lt;</td><td>less than</td></tr>
+<tr><td width="10%">&nbsp;</td><td>&gt;&#061;</td><td>greater than or equal to</td></tr>
+<tr><td width="10%">&nbsp;</td><td>&gt;</td><td>greater than</td></tr>
+<tr><td width="10%">&nbsp;</td><td>&lt;&gt; </td><td>not equal to</td></tr>
+</table>
+</html>
+Use caution with leading blanks in the comparison value field; do not enclose the test operator or the comparison value in quotes.
+ * ** *CURROW**: Specify the current row.
 \\