pronoun
Returns the pronoun (e.g. I, you, he, she, they) for the input gender or name.
The optional parameters allow you to specify the pronoun type.
Parameters
GENDER OR NAME (string)
The input gender or name.
Recognized values for gender: Male, Female, male, female, M, F, m, and f.
For names, only the first name (e.g. 'John' in 'John Rose') is analyzed.
NUMBER (string)
Optional. Whether the pronoun is singular or plural.
Default: singular
TYPE (string)
Optional. The pronoun type. Options: subject, object, reflexive, possessive, and nominal.
Default: subject
PERSON (number)
Optional. Whether the pronoun is first, second, or third person. Specify 1, 2 , or 3.
Default: 3
IS PERSON (Boolean)
Optional. Whether the pronoun is for a person (true) or thing (false). This applies to third-person pronouns only, so relevant only when PERSON = 3.
When IS PERSON = true and the gender is unknown, the function returns a gender-neutral pronoun.
Default: true
Examples
The first parameter can take a name or gender.
ATL in Script | Result |
|---|---|
| she |
| she |
Note
For all recognized values for gender, see the parameter description.
By default, the function returns singular pronouns. Use the second parameter to specify plural.
ATL in Script | Result |
|---|---|
| she |
| they |
Use the third parameter to specify the pronoun type. Subject applies by default.
ATL in Script | Result |
|---|---|
| she |
| her |
| herself |
| her |
| hers |
Use the fourth parameter to make the pronoun first person, second person, or third person.
ATL in Script | Result |
|---|---|
| she |
| I |
| you |
| she |
Use the fifth parameter to define whether the pronoun is for a person (true) or thing (false) This applies to third-person pronouns only, so the fourth parameter value must = 3.
ATL in Script | Result |
|---|---|
| hers |
| its |
The function assigns a gender to the input name through reference to a census database of American first names. If the input name is unrecognized, the function returns a gender-neutral pronoun.
ATL in Script | Result |
|---|---|
| their |
| them |
Note
The above applies only when PERSON = 3 and IS PERSON = true (both are default values).
You might want gender-neutral pronouns for someone with a male-typical or female-typical name. For example, the function treats 'Emma' as female, but an Emma might identify as non-binary (or gender fluid, agender, etc.) and prefer gender-neutral pronouns. To handle this, you need gender values in your dataset.
Assume a "Describe Each Row" project with this data:
Name | Gender | Department | startDate | |
|---|---|---|---|---|
Row 1 | Emma Watson | F | Sales | 2019-03-18 |
Row 2 | Emma Corrin | NB | Marketing | 2022-04-15 |
The function doesn't recognize a value like 'NB' (non-binary) and therefore returns a gender-neutral pronoun. This is the desired output in this case, so reference Gender instead of Name.
[[Name]] works in [[Department]]. [[pronoun(Gender)]] joined Arria on [[parseDateTime(startDate)]].
The output for Row 1:
Emma Watson works in Sales. She joined Arria on Mar 18, 2019.
The output for Row 2:
Emma Corrin works in Marketing. They joined Arria on Apr 15, 2022.
