Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I am trying to fetch data from Mongodb toward Qlikview.
The issue I'm facing is that when I run the script where I select my Mongodb collection, the number of lines fetched is different from the mongodb collection.
I have a total of 30094 lines in my mongodb collection. However, Qlikview says that I fetched only 4096 lines (eventhough I do a 'SELECT *' to my collection in the script section).
Help would be very much appreciated.
After "Select *" did you applied any where conditions? Are you seeing (qvd optimized) on the Script execution window.
If not, you might be applying some filter.
I don't have any where conditions after my SQL statement.
The only thing the script window is returning is this :
"Connecting to MongoDB_ODBC
Connected
Bonbon_collection 4 096 Lines fetched"
Here is a small sample of my collection file : https://pastebin.com/Q8vq7dAU
I think it might has something to do with the JSON formating of my collection