Loading zeros in MongoDB

AG-gugelbisolutions — Thu, 23 Dec 2021 20:04:06 GMT

Hi there, in one of the projects I am involved in we have a MongoDB source. While we are still not able to use the built in connector (see my other unanswered post), we discovered that, for some reasons, Qlik Sense is randomly adding some leading zeros when reading a field. Sometimes it adds leading zeros; sometimes it does not.

Let me clarify with an example.

From products I get

Tenant ID	SKU
tenant1	000020767
tenant2	000020767

But the right value, the one users see in Mongo, is 20767 and this is causing the application of a map to fail because, for example, from movements I get

Tenant ID	SKU
tenant1	20767
tenant2	20767

Curiously, though, if I left join these two tables it succeeds, probably because Qlik Sense uses the numeric representation rather than textual values.

I already tried to apply any kind of transformation and formatting function without success. text(...) was the first (in preceding load), but I also tried cast/convert (both explicit and implicit, directly applied to the SQL code).

It sounds like some sort of driver issue to me, but I'm using the latest available (1.4.2). Don't know the BI Connector version though.

Any ideas?

topic Loading zeros in MongoDB in Connectivity & Data Prep

Loading zeros in MongoDB