topic Re: Data truncating preceding Special Charater while Loading. in QlikView

Data truncating preceding Special Charater while Loading.

Anonymous — Wed, 29 Nov 2017 12:02:37 GMT

Hi ,

I am trying load data from excel.

One of column has element JUAN IÑIGO but in Qlikview only IGO is coming.

One way solve is to use mapping load along with Applymap() function to map IGO with JUAN IÑIGO.

This can done by keeping a separate mapping table in excel or in an Inline table in Qlikview.

But I am trying to find solution apart from the above one where I don't have to use Mapping load..

Any response is greatly appreciated.

Anil_Babu_Samineni — Wed, 29 Nov 2017 13:17:14 GMT

How come? Can you describe with data you loading from image and into Qlikview image?

gballester — Wed, 29 Nov 2017 13:25:51 GMT

Hello,

Doing a test in version 12.20 I have no problem loading excel from that data.

What versions of excel and Qlik View are you using?

Guillermo

Anonymous — Thu, 30 Nov 2017 05:49:55 GMT

Excel version 2013

QlikView Version : 12.0.20

Still the same issue persists.

gballester — Thu, 30 Nov 2017 19:55:23 GMT

I’m use the QlikView version 12.20.20100.0 and excel version 2013 (15.0.4963.100), and not have problem to load this data.