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 17 days ago