You are not logged in.
Unanswered posts
|
Julietzhao0006 said:
Hello Guys,
when I insert a row in Mongo shell:
db.mycoll.insert(
{
"column1": [
"AAA123",
"BBB123"
]
}
)
result is:
{ "_id" : ObjectId("58b82d52957107b7c5d11062"), "column1" : [ "AAA123", "BBB123" ] }
but when I load data with Talend tMongoDBOutput component, even I choice column1's data type is "Object" in output side, Talend still load it as string, result like this:
{ "_id" : ObjectId("58b82d52957107b7c5d11062"), "column1" : "[ "AAA123", "BBB123" ]" }
Because input_row is from Oracle, it is string, so I tried to add a tJavaRow component convert the string to array, but I can not set the result value to ouput_row which is tMongoDBOutput component's input_row, so anybody know What the best way I can do to resolved this problem? By the way, I must use Talend tMongoDBOutput to do it.
Thanks
Offline
xdshi said:
Hi,
You can perform this by passing an array of json documents to the insert method on a collection in the mongo shell?
Have you tried this "function" in tMongoDBRow to see if it works?
Best regards
Sabrina
What we can do is to make sure that Talend will be your best choice!
Offline