Specifying Column Order when Exporting CSV

Randy AufDerHeide shared this question 20 months 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