header-map

Renames column header names

pebblestream:header-map("Header Old", "Header New"[, ...])

Header Old is renamed to Header New, specified in pairs.

Example

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


Did this page help you?