9 Replies Latest reply: May 4, 2009 5:45 PM by Michael Solomovich RSS

    Load field with inizial space

    Teamsystem Teamsystem

      Good Morning,

      i have a database SQL with a table with two fields (Code - char 20 / Description - char 40). Sometimes the Code field is populated not from column 1 (see examples) and when i LOAD the Code field in Qlikview the initial spaces are left out.

      Example column CODE Load in Qlikview

      001 002 01 001 002 01

      001 02004 001 02004

      002 01 002 01

      I would like the LOAD command to respect the data of the database:

      Load in Qlikview

      001 002 01

      001 02004

      002 01

       

      How can i do it ?

      Thank You

      Paolo