Specifying Column Order when Exporting CSV

qinghai (support@nosqlbooster.com) ●

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)

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)

Reply URL

1

Randy AufDerHeide ●

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?

Reply URL

1

qinghai (support@nosqlbooster.com) ●

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")

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")

URL

Specifying Column Order when Exporting CSV

Replies (2)