Solved: Re: Qlikview developer - Qlik Community

mohanrao123 · ‎2020-09-30

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.

edwin · ‎2020-09-30

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).

View solution in original post

edwin · ‎2020-09-30

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).

Brett_Bleess · ‎2020-10-21

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.