Skip to main content

Tail

Return the last n rows.

Return the last n rows

Parameters​

NameDescriptionAccepted ValuesDefaultRequired
Options
nNumber of rows to return.integer—Yes
Conditions
ifCondition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}.string—No
whereFilter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'.string—No
where_paramsValues used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name.array, object—No

Examples​

wrangles:
- select.tail:
n: 2
ProductManufacturer
Ball BearingSKF
Bearing RaceTimken
Needle BearingAcme Bearings
Roller BearingGeneral Bearing Co.
ProductManufacturer
Needle BearingAcme Bearings
Roller BearingGeneral Bearing Co.
Access
RequirementValue
AI-poweredNo
Requires WrangleWorks accountNo
Requires subscriptionNo
Requires external API keyNo
Technical details
FieldValue
Catalog ID61
Catalog keyselect.tail
Recipe keyselect.tail
Catalog statusactive
Lifecycle statusactive
Recipe Writer eligibleYes
Namespaceselect
Documentation groupselect
AliasesNone
Runtime symbolwrangles.recipe_wrangles.select.tail
Legacy UUID60853759-c160-49a4-87eb-036516a9d823

Sources