# tStem

Enables to standardize data in columns before matching this data.

tStem standardizes data in columns through the process of linguistic normalization, in which the variant forms of a word are reduced to a common form.

This component is not shipped with your Talend Studio by default. You need to install it using the Feature Manager. For more information, see [Installing features using the Feature Manager](https://help.qlik.com/talend/r/en-US/8.0/studio-user-guide/install-features-to-talend-studio).

## tStem Standard properties

These properties are used to configure tStem running in the Standard Job framework.

The Standard tStem component belongs to the Data Quality family.

This component is available in Talend Data Management Platform, Talend Big Data Platform, Talend Real-Time Big Data Platform, Talend Data Services Platform and in Talend Data Fabric.

## Basic settings

| Properties | Description |
| --- | --- |
| Schema and<br>Edit schema | <ul> <li> <p>A schema is a row description, it defines                                                  the number of fields to be processed and passed on                                                  to the next component. The schema is either                                                  <span>Built-in</span> or                                                  stored remotely in the <span>Repository</span>.</p> </li> <li> <p> <span>Built-in</span>:                                                  You create the schema and store it locally for                                                  this component only. For more information about a component schema in its <span>Basic settings</span> tab, see <a href="https://help.qlik.com/talend/r/en-US/8.0/studio-user-guide/basic-settings-tab" target="_blank">Basic settings tab</a>.</p> </li> <li> <p> <span>Repository</span>:                                                  You have already created the schema and stored it                                                  in the Repository. You can reuse it in various                                                  projects and Job designs. For more information about a component schema in its <span>Basic settings</span> tab, see <a href="https://help.qlik.com/talend/r/en-US/8.0/studio-user-guide/basic-settings-tab" target="_blank">Basic settings tab</a>.</p> </li> </ul> |
| Select Algorithm | Set a stemming algorithm for each analyzed<br>column of the type<br>*string*.<br><br><br>Column: list of<br>the analyzed column.<br><br><br>Algorithm: Select<br>from the list the algorithm language you want to<br>check the column data against. |

## Advanced settings

| Properties | Description |
| --- | --- |
| tStatCatcher<br>Statistics | Select this check box to collect log data at<br>the component level. |

## Global Variables

| Variables | Description |
| --- | --- |
| Global<br>Variables | ERROR\_MESSAGE: the error message generated by the<br>component when an error occurs. This is an After variable and it returns a string. This<br>variable functions only if the Die on error checkbox is<br>cleared, if the component has this checkbox.<br><br>A Flow variable functions during the execution of a component<br>while an After variable functions after the execution of the component.<br><br>To fill up a field or expression with a variable, press Ctrl+Space to access the variable list and choose the variable to use from<br>it.<br><br>For more information about variables, see [Using contexts and variables](https://help.qlik.com/talend/r/en-US/8.0/studio-user-guide/contexts-and-variables). |

## Usage

| Usage guidance | Description |
| --- | --- |
| **Usage rule** | This component is an intermediary step. It<br>requires an input flow as well as an<br>output. |

**Related concepts**

* [Extracting the stems of English words from a specific DB column](https://help.qlik.com/talend/en-US/components/8.0/text-standardization/tstem-tfilterrow-taggregaterow-tfileoutputexcel-extracting-stems-of-english-words-from-specific-db-column-standard-component-enterprise-this)
* [Generating stems for a list of English words](https://help.qlik.com/talend/en-US/components/8.0/text-standardization/tstem-tmap-tfileinputdelimited-tlogrow-generating-stems-for-list-of-english-words-standard-component-enterprise-this)