# Creating parameterized expressions

You can create parameterized expressions by clicking ![DSQL Parameterized Expressions](https://help.qlik.com/talend/en-US/data-mapper-user-guide/Resources/images/func-arg.svg) DSQL Parameterized Expressions on the top bar.

## DSQL Parameterized Expressions view

![DSQL Parameterized Expressions view.](https://help.qlik.com/talend/en-US/data-mapper-user-guide/Resources/images/parameterized-expression-ui.png)

| Properties | Description |
| --- | --- |
| New parameterized expression | Click ![New parameterized expression](https://help.qlik.com/talend/en-US/data-mapper-user-guide/Resources/images/add.svg) to create a new parameterized expression, and enter a name.<br><br>The name of the<br>new parameterized expression must be a valid DSQL identifier, and must be<br>unique. |
| Delete parameterized expression(s) | Click ![Delete parameterized expression(s)](https://help.qlik.com/talend/en-US/data-mapper-user-guide/Resources/images/delete.svg) to delete one or more selected parameterized expressions. |
| Sort parameterized expressions | Click ![Sort parameterized expressions](https://help.qlik.com/talend/en-US/data-mapper-user-guide/Resources/images/sort.svg) to sort the created parameterized expressions alphabetically in the<br>list. |
| type filter text | Enter any text to filter the created parameterized expressions. |
| Name | Enter a name for the parameterized expression.<br><br>The name is case insensitive<br>and must be unique. |
| Description | Enter a description for the parameterized expression. |
| Parameters | Enter one or more parameters, separated by a comma.<br><br>If the parameterized<br>expression has no parameter, let the field empty.<br><br>Information noteTip: If you want to<br>rename a parameter that is already used in the expression, you can right-click and<br>select Rename parameter. All the references to the old name<br>are then updated with the new name in the expression. |
| Expression | Enter the expression to be used in the parameterized expression. The expression<br>can contains:<br><br><ul> <li>a <span>Data Shaping Expression Language</span>                  expression<pre><code><pre><code><code>concatWith(delimiter, address.street, address.city)</code></code></pre></code></pre></li> <li>a block<pre><code><pre><code><code>{            street = address.street,            city = address.city,            zipcode = address.zipcode}</code></code></pre></code></pre></li> <li>a query or a sub-query<pre><code><pre><code><code>(            FROM cust            SELECT {              custid = custid,              name = name,              address = genAddress(address),              rating = rating  }) </code></code></pre></code></pre></li> <li>a comment</li> <li>a recursive expression</li> </ul><br><br>Information noteTip: You can drag and drop a function or an input map element in the<br>content of the parameterized expression. |

Information noteTip: You can change the view of the DSQL Parameterized Expressions view from vertical to horizontal by clicking ![Switch Layout](https://help.qlik.com/talend/en-US/data-mapper-user-guide/Resources/images/param_expr_view_layout.svg) Switch Layout.