header-map
Renames column header names
pebblestream:header-map("Header Old", "Header New"[, ...])
Header Old is renamed to Header New, specified in pairs.
Consider the worksheet Raw Accounts
| ID | Balance | Last Name |
|---|---|---|
| 0 | 4233 | Jones |
| 1 | 21 | Smith |
| 2 | 0 | George |
| 3 | 33 | Jones |
Apply the following directive declaration to remap headers:
pebblestream:from("Raw Accounts")
pebblestream:header-map("Balance", "VALUE", "Last Name", "OWNER_LAST")
To create the DB-friendly Accounts worksheet:
| ID | OWNER_LAST | VALUE |
|---|---|---|
| 0 | Jones | 4233 |
| 1 | Smith | 21 |
| 2 | George | 0 |
| 3 | Jones | 33 |
Updated over 3 years ago