My favorites | Sign in
Project Home Downloads Wiki Issues Source
Search
for
PivotUserDocs  
pivot - pivots flat-file data from rows to columns
Updated Feb 4, 2010 by jeremy.h...@gmail.com

Usage

pivot <options> [file ...]

-f, -p, and -v values are comma-separated numbers or ranges. for example:

1,2-5,7

Options

Short OptLong OptArgumentDescription
-h--help print this message and exit
-V--version print version info and exit
-d--delimiter
<delim>
field separator string
-k--keep-header indicates that the first line of input should be treated as header info
-f--output-fields
<keys>
indexes of row fields to output
-F--output-labels
<key_labels>
labels of row fields to output
-p--pivot-fields
<pivots>
indexes of column fields to pivot on
-P--pivot-labels
<pivot_labels>
labels of column fields to pivot on
-v--value-fields
<values>
indexes of data fields to put into the pivoted cells
-A--value-labels
<value_labels>
labels of data fields to put into the pivoted cells


back to UserDocs


Sign in to add a comment
Powered by Google Project Hosting