Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
vincentkars
New Contributor II

Loading data in Excel

If have a simple load statement

LOAD

    Nationaliteit,

    Soort,

    Bouwjaar,

    jaar,

    aantal

FROM [lib://SWOV_XLS (qlik_kars)/VrachtL.xlsx]

(ooxml, embedded labels, table is Data);

Column Soort contains the following value

Vrachtauto gewicht volle wagen >= 20 t

In the app only "= 20 t" is displayed

How do I load the full text?

I tried

    text(Soort) as Soort,

but that doesn't help

Tags (2)
4 Replies
mwoolf
Honored Contributor II

Re: Loading data in Excel

try apostrophes around 20 t

Partner
Partner

Re: Loading data in Excel

What release of QlikSense are you using?  I am using the June 2017 desktop release and I am getting the entire field when I bring in an excel with what you put for your data field (see attached).  Does your field perhaps have an embedded non-visible ascii character that might be splitting the field in 2?

Here is my load statement

LOAD

    Soort

FROM [lib://Excel/Test_data.xlsx]

(ooxml, embedded labels, table is Sheet1);

vincentkars
New Contributor II

Re: Loading data in Excel

I'm using 3.2.3, the web version

If I replace ">=" by "gt" in Excel then the whole string is read correctly

If I change "gt" by ">=" in Excel then the whole string is read correctly

This sheet is an Excel created by SAS.

I generated it anew, got the =20 t again

Open the Excel and set the column Soort to type Text

Now the whole string is read correctly!

Thanks for your help

sonkumamon
New Contributor III

Re: Loading data in Excel

When defining the table separator and language, try changing the Quoting from MSQ to None, maybe it will help.