Relation:rename
Renames columns in the current expression.
Description
rename name newname (, name newname...)
Parameters
- name: must be a valid name.
- newname: must be a valid name.
Examples
Using the sample relation films.csv
rename film titre, director realisateur, year annee
| titre | realisateur | annee |
|---|---|---|
| A bout de souffle | Godard | 1960 |
| Tirez sur le pianiste | Truffaut | 1960 |
| Cléo de 5 à 7 | Varda | 1962 |
| Jules et Jim | Truffaut | 1962 |
| Pierrot le fou | Godard | 1965 |
| Week-End | Godard | 1967 |
| Die verlorene Ehre der Katharina Blum | von Trotta | 1975 |
| Der starke Ferdinand | Kluge | 1976 |
| Sans toi ni loi | Varda | 1985 |
Comments
Rename ma be needed when you combine tables or want to label tabels properly.
Note that you cannnot use accented characters in names. annee is ok, année is not ok.
The number of rows and the order stays the same.