Sorting and Filtering Columns in the Input and Output Panes

Items in the Input and Output panes display in the order that they are received from the data source. When preparing to map columns for transforms, sorting and filtering the list of names, data types, and descriptions may make your mapping effort easier.

Sorting

You can sort the list of table and extractor columns in the Input and Output panes by clicking on Name, Data Type, and Description. A bold arrow indicates either an ascending or descending alphanumeric sort.

Filtering

You can filter the list of table and extractor columns in the Input and Output panes by entering text in one or more of the text fields beneath Name, Data Type, and Description and then pressing Enter. The system accepts partial entries as well as numbers in these fields and returns any name, data type, or description containing the text you have entered in the respective column's text field. You can also utilize RegEx operators when filtering in the Input and Output panes; some commonly-used filter operations are shown in the following table:

Character	Function	Example of Filter	Example of Results
\|	Matches rows of the expression on the right AND/OR the left side	id\|file	"id", "file"
[]	Matches any one of the enclosed characters	[abc]id	"aid", "bid" and "cid"
-	The minus sign represents a range of characters	[a-d]1	"a1", "b1", "c1" and "d1"
.	The dot matches any single character	a.b	"aab", "abb", "acb", ... "azb", "a!b", etc.
*	Indicates zero or more occurrences of the preceding element	ac*b	"ab", "acb", "accb", "acccb", etc.
+	Indicates one or more occurrences of the preceding element	ac+b	"acb", "accb", "acccb", etc.
?	Indicates zero or one occurrences of the preceding element	ac?b	"ab" and "acb"
{n}	Indicates the preceding item is matched exactly n times	a{2}	"aa"
()	Encloses an entire expression	a(c+\|f+)b	"acb", "accb", ... "afb", "affb", etc.
^	Matches all rows starting with the succeeding element	^abc	Displays results starting with "abc"
$	Matches all rows ending with the preceding element	abc$	Displays results ending with "abc"
\	Escapes a character	\?	Displays results containing "?"

To reset a filtered list, delete any text you entered in the filter text fields, then press Enter.

Considerations When Sorting and Filtering Columns for Transforms

An asterisk (*) does not function as a wildcard on its own. You must use an asterisk in combination with the dot (.) special character. For example, filtering with abc.* returns all text strings that begin with “abc”.
To include any nested items in your sort or filter results, you must first expand their parent nodes.
Sorted and filtered lists are not saved when you leave the Transform page.