-
Type: Question
-
Resolution: Done
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Labels:None
i have data in my collection in below format
{
"_id" : ObjectId("59a7ff69e01fee556442c309"),
"TestData" : [
,
{ "Policy" : null, "Type" : "Upfront", "AccrualDate" : "2004-08-01", "ReceivableDate" : "2004-07-29", "IsOverriden" : false, "IsUpfront" : true, "AmountReceived" : 148288.64, "ReceivedDate" : "2004-09-24", "AmountDue" : 148289.0, "ParBalance" : 6160000.0, "AccrualDateTo" : "2004-08-01T00:00:00", "IsUncollectible" : false, "AccrualRate" : 1.0, "ReceivedRate" : null, "StatusChangeComment" : null, "ReceivedStatus" : "Received", "Discriminator" : "1" } ]
}
--on top of this collection i have created view to retrieve the Premiums data below is the view script
db.createView("TestView","Mycollection",[ { $project: { "Type": "$TestData.Type","AccrualDate":"$TestData.AccrualDate","ReceivableDate":"$TestData.ReceivableDate",
"IsOverriden":"$TestData.IsOverriden","IsUpfront":"$TestData.IsUpfront","AmountReceived":"$TestData.AmountReceived","ReceivedDate":"$TestData.ReceivedDate","AmountDue":"$TestData.AmountDue",
"ParBalance":"$TestData.ParBalance","AccrualDateTo":"$TestData.AccrualDateTo","IsUncollectible":"$TestData.IsUncollectible","AccrualRate":"$TestData.AccrualRate",
"ReceivedRate":"$TestData.ReceivedRate","StatusChangeComment":"$TestData.StatusChangeComment","ReceivedStatus":"$TestData.ReceivedStatus"
}} ])
Now i am reading data from view using SSIS , i am getting data in below format in single row
59a7ff69e01fee556442c309 ["Upfront", "Upfront"] ["2004-07-29", "2004-08-01"] ["2004-07-29", "2004-07-29"] [false, false] [true, true] [null, 148288.64000000001] [null, "2004-09-24"] [0.0, 148289.0] [6160000.0, 6160000.0] ["2004-07-29", "2004-08-01"] [false, false] [1.0, 1.0] [null, null] [null, null] ["TrueOutstanding", "Received"]
we have two records in test data object we need single row for each record.