CorpGlory / csv2influx

A CLI tool for importing CSV files into Influxdb
MIT License
16 stars 6 forks source link

Possibility to merge all columns #28

Closed jonyrock closed 6 years ago

jonyrock commented 7 years ago

Now it's possible to merge only date-related columns like this

"time": ["Date", "Time"]

It would be cool to be able merge all columns

"name": ["First Name", "Last Name"]
lyondhill commented 7 years ago

With merging the colums it may be useful to identify how you want them to merge. Some may want them to merge with spaces ('first_name last_name'). Some may want you to merge with commas, and others may want you to merge in a completely different way.

Imagine a csv has Street,City,State,Zip, you may want to merge those as "Street\nCity,State\nZip".

jonyrock commented 7 years ago
jonyrock commented 6 years ago

@lyondhill check this out

"fieldSchema": {
      "coordinates": {
        // fields "Latitude" and "Longitude" will be concatenated 
        // with "," delimiter to create "coordinates" field
        "from": "${Latitude},${Longitude}",
        "type": "string"
      }
    },

Please see examples In version 0.12 it is now available.

P.S. How do you thing, is it worth a star here on github ? :)

lyondhill commented 6 years ago

I like the flexibility of interpolation. It looks really nice!