Find
What is the ‘Find’ task?
The ‘Find’ task can be used to find content in a data table. The task creates a new column in the output table, that houses the results.
The ‘Find’ task is useful tool to analyse and review the contents of a data table.
How to use the ‘Find’ task?
The important fields in the ‘Find’ task are
- Select Table
Use this dropdown menu to select the table which has the data entries you would like to find.
- Column Name for Match Status
Use this field to type in the name of the column that will house the results in the output table. In this column, the entries that have the content to be found, will be indicated as ‘TRUE’, and all other entries will be indicated as ‘FALSE’.
- Custom Delimiter for Multiple Entries
Use this this checkbox to indicate if you would like to have multiple matches separated with a custom delimiter.
For example, searching for ‘p’ in the word ‘apple’ leads to ‘TRUE;TRUE’.
- Don’t Duplicate Same Matches
Use this this checkbox to indicate if you would like to not duplicate same matches.
For example, avoiding duplicates, the search for ‘p’ in the word ‘apple’ leads to ‘TRUE’, and not to ‘TRUE;TRUE’.
How to use the ‘Filter Options’ section in the ‘Find’ task?
The ‘Filter Options’ section in the ‘Find’ task can be used to modify features of the output table.
More information about this section is available here.
How to use the ‘Define Output Table’ and the ‘Output Options’ sections in the ‘Find’ task?
The ‘Output Options’ section in the ‘Find’ task can be used to modify features of the output table. The fields related to this section become visible on selecting the ‘Output Options’ checkbox.
More information about this section is available here.
