Data truncating preceding Special Charater while L... - Qlik Community

Anonymous · ‎2017-11-29

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 · ‎2017-11-29

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

gballester · ‎2017-11-29

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 · ‎2017-11-30

Excel version 2013

QlikView Version : 12.0.20

Still the same issue persists.

gballester · ‎2017-11-30

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.

Data truncating preceding Special Charater while Loading.