Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue while fetching mongodb data to Qlikview

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.

2 Replies
balabhaskarqlik

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.

Not applicable
Author

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