Specifying Column Order when Exporting CSV

Randy AufDerHeide shared this question 2 years ago
Answered

When exporting data as csv, is it possible to specify the column order?

It would make our import/exports into Google Sheets a lot easier.

Replies (2)

photo
1

There is a work-around solution. NoSQLBooster can export query results. You can add field selection(.project) and sorting methods(.sort) to the query. You can also use the one-click projecting and one-click sorting operation to generate related query code. Then export the query to a CSV file.

BTW, you can export the dataset to excel and then use excel for field selection and sorting.

408c9ccd9c3be0ed801f4e676e5a352c

For example:


db.unicorns
    .find({})
    .projection({  //select your columns
        name: 1,
        loves: 1,
        weight: 1,
        gender: 1
    })
    .sort({ //sorting
        weight: -1,
        gender: -1
    })
    .limit(11)

photo
1

Thank you for the feedback. I don't think this addresses my concern but it may be because I wasn't clear.

When I export data, I need the fields/columns to be in a specific "position".

For example, when I export, I may want:

Field 1: Weight

Field 2: Gender

Field 3: DOB

Field 4: Name


and just to be clear, lets say I want another saved query to have the columns export like this:

Field 1: DOB

Field 2: Weight

Field 3: Gender

Field 4: Name


** I know some people might say you should do this in another app but if its possible to do it when I export the data, it makes things a lot easier.


Is this possible?

photo
1

You can adjust the order of field exports through the projection method, and you can save the query or save it as a read-only view for later use.


db.example
    .find({})
    .projection({
            Dob: 1,
            Weight: 1,
            Gender: 1,
            Name: 1
      })
      // .saveAsView("query_view")

photo
Leave a Comment
 
Attach a file