Aggregate Commands for Redmart Addresses

db.members.aggregate([
    {$unwind: "$addresses"},
    {$project: { _id: 0, first_name: {$replaceAll: {input: {$toLower: "$addresses.first_name"}, find: " ", replacement: ""}}, last_name: {$replaceAll: {input: {$toLower: "$addresses.last_name"}, find: " ", replacement: ""}}, postcode: "$addresses.postcode" }},
    {$out: "aggregate_addresses"}
  ])

db.members.aggregate([
    {$unwind: "$credit_cards"},
    {$project: { _id: 0, first_name: {$replaceAll: {input: {$toLower: "$credit_cards.billing_address.firstname"}, find: " ", replacement: ""}}, last_name: {$replaceAll: {input: {$toLower: "$credit_cards.billing_address.lastname"}, find: " ", replacement: ""}}, postcode: "$credit_cards.billing_address.postal_code" }},
    {$merge: {into: "aggregate_addresses"}}
  ])

.\mongoexport --db redmart --collection aggregate_addresses --out addresses.json

db.addresses.ensureIndex({first_name:1,last_name:1,postcode:1},{unique:true})

.\mongoimport.exe --db redmart --collection addresses --file .\addresses.json

Count: 1275267

# https://research.reignofcomputer.com/