unflatten

Commands ››
Parent Previous Next

The unflatten command is used to convert multiple values on the same row into multiple rows. It is the inverse of the flatten command.

Flag

Req'd?

Description

-k key

No

Specifies one or more key fields. Default is to use the first field as the key

-n ndata

No

Specifies how many data items to output on each row - default is 1.



The following example converts the file unflat.csv into multiple rows:

csvfix unflatten data/unflat.csv

producing:

"1","a"
"1","b"
"1","c"
"2","d"
"2","e"
"3","f"
"3","g"
"3","h"
"3","i"

Created with the Personal Edition of HelpNDoc: Free Web Help generator