Hi,
I am trying to import data from SQL Server and i need to create one field in the document as an array and add all the values related to the document from child table. please see the example below.
Table 1: Manufacturer
Manufacturer_Id Make Year
1 Mercedes 2017
2 BMW 2017
Table 2: Models
Manufacturer_Id Model_Id Model Name
1 1001 C300
1 1002 C350
2 1003 328i
3 1004 328Xi
I want the document to look something like the below.
{
"_id": 1
"manufacturer": "Mercedes"
"year": 2017
"model": ["C300", "C350"]
}