Best way to bulk convert field type to do double

Working with Data
1

I’m wanting to work with prisma and some of my field types are not uniform, as in all double.
is there a way to bulk convert them all to double in compass, or is there a way to do it with the mongo shell

3

Hello @Richard_Locke ,

Welcome to The MongoDB Community Forums! :wave:

I notice you haven’t had a response to this topic yet - were you able to find a solution?
If not, could you please share below details for me to understand your use case better?

  • I do not understand what you mean by that, do you want to convert selective field types in one document to double or do you want to update all the field types in your documents to be converted to double? Please explain your use-case.
  • MongoDB Version
  • Any query that you have worked on?
  • Some sample documents
  • Expected output documents

Regards,
Tarun