no way to compare when less than two revisions

Differences

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

@@ Line 1: / Line 1: @@
+====== ColumnExists(col_name) ======
+Category:  Special function
+\\
+=====Description=====
+This function tests whether a column named //col_name// exists in the input dataset.  TRUE is returned if the named column exists, otherwise, FALSE is returned.
+\\
+=====Arguments=====
+^Argument^Type^Description^
+|col_name|Text  |The name of a column to test for within the input dataset.  |
+**Return value type:** Boolean (TRUE/FALSE)
+\\
+=====Remarks=====
+This function is case sensitive.
+\\
+=====Examples=====
+\\
+**Sample dataset:**
+^ Amount  ^ Description ^
+|  200 | Product A  |
+|  3000| Product B  |
+Given the dataset above, ColumnExists() would return the following results:
+  columnexists('Description') = TRUE
+  columnexists('description') = FALSE  //Function is case-sensitive
+  columnexists('Price') = FALSE