topic Re: Qlikview developer in QlikView

Qlikview developer

mohanrao123 — Wed, 30 Sep 2020 09:47:12 GMT

Hi All,

I tried to load excel data one column name description column data JPMORMAN CHASE & CO but I am getting data only CO.

I need JPMORMAN CHASE & CO I have attached sample data any one help me.

Re: Qlikview developer

edwin — Wed, 30 Sep 2020 10:27:40 GMT

use the file load wizard. when i loaded your file (in the load script menu: INSERT>LOAD STATEMENT>INSERT FROM FILE):

LOAD Descrption,
Ticker
FROM
[C:\Users\XXXXX\Downloads\sAMPLEDATA1.xlsx]
(ooxml, embedded labels, header is 5 lines, table is Sheet1);

i get this:

or show your script (just the load part for the XLS).

Re: Qlikview developer

Brett_Bleess — Wed, 21 Oct 2020 21:12:03 GMT

Believe the issue would most likely be related to the & character in that line being interpreted, but it appears if you follow @edwin that should take care of getting the correct settings into the load statement to avoid that issue.

Regards,
Brett