4 Replies Latest reply: Jul 25, 2017 5:09 AM by uri ophir RSS

    Loading data in Excel

    Vincent Kars

      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