key:value pair importer

[GoogleCodeExporter]

I am looking for a general key:value pair importer.

The source is a 3 column table with: object, key, value.
The desired output is a column for each key and a row for each object. with the 
value filled in to the corresponding cell.

It would be great to then use the facets and Cluster features to clean up as 
usual

i.e.
in:
car, color,blue
car, style,sedan
out
object,color, style
car,blue,sedan

Original issue reported on code.google.com by chr...@gmail.com on 5 Jan 2011 at 6:04

[GoogleCodeExporter]

Would the proposed new UI screenshots in Issue 285 make sense for your 
importing option needs regarding key:value ?

Original comment by thadguidry on 5 Jan 2011 at 6:30

[GoogleCodeExporter]

The UI looks great!
I don't see a specific parser that would work but if I could figure out how to 
write an Extension that would be cool.

Also, I keep thinking there should be an easy way once importing it to convert 
it. The structure is similar to json but I don't see an easy way to make the 
conversion.

Original comment by chr...@gmail.com on 5 Jan 2011 at 6:47

[GoogleCodeExporter]

I think just modifying the template during Export could help with your 
conversion needs ?  http://code.google.com/p/google-refine/wiki/Exporters

Original comment by thadguidry on 5 Jan 2011 at 7:00

[GoogleCodeExporter]

Original comment by tfmorris on 8 Oct 2011 at 7:12

• Added labels: Type-Enhancement
• Removed labels: Type-Defect

[GoogleCodeExporter]

Using the text line importer and then using Transpose -> Key/Value transpose 
after the import.

Original comment by tfmorris on 18 Sep 2012 at 7:08

• Changed state: Fixed