Convert Json data into Table return from Qlik Mongo DB Web Connector

[rohitk1609]

HI techies,

I am using Qlik Web connector licensed for Mongo DB. I have created a connection with a collection and fetch 4 columns. one column under sub doc has data in array or json format. Json format value is not constant in length or size it could be null or blank as [] also. Look at the below two records, first one has two parts Rohit and Kumar and second record has only Tony.

[{ "name" : "4050 Rohit", "id" : 881 }, { "name" : "4053 Kumar", "id" : 883 }]

[{ "name" : "4050 Tony", "id" : 881 }]

Now I need to convert the array or json data into two columns first will be name and second will be id.

Is there anything I need to set in Qlik Web mongo DB connector from https://docs.mongodb.com/manual/reference/operator/query/ so json data in field will be parsed before loading into Qlik ?

Can you please guide me how to do it ?

Thanks in advance

Rohit

[Marcus1]

Hello Rohitk1609,

I know this question was posted a long time ago, but maybe this help someone in future. I had a similar problem, if I am right as far as I could understand from what you said, what solved to me was to upgrade de numbers of lines read by qlik sense to create the metadata to load data. to do that you have to upgrade the amount of lines to be read to create the metadata into your connection, to the field "Sampling Count"
the standard value is 100 I had put 1500  but you can change according to your need.

Any questions about those patterns could be found here:

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Mongo/...

Please let me know if I helped.