0 Replies Latest reply: Sep 27, 2016 4:13 AM by Marcello Aondio RSS

    Different Accent Coding QlikServer

    Marcello Aondio

      Hi everybody,

       

      i have this trouble while loading .txt file on server.

      The problem we found is that the field " società " has the character "à" coded with a hex code other than what's in the script, then the "à" that is in the source files (.txt) it is different from "à" that is in the script.

      We also realized that the one present in the file is actually an " à " (with a tilde), anyway the ETL code check the field so if it doesn't  find the " Società " should load " Società " (see below )

      TAb1:
                     
      LOAD [Nr.doc.] As [document ID],
                          
      Società,
                          
      '-' As [Soc. Doc partners.]
         
      dates (makedate ...

      FROM [aa.txt]
      (Txt, code page is 1252, embedded labels, delimiter is '|', no quotes, header is 3 lines, filters (
      Remove (Col, Pos (Top, 1)),
      Remove (Row, Position (Top, 2))))

      Error: Field not found - <Società>

      if ScriptError=11 then

      Tab1:

                      LOAD [Nr.doc.] as [ID documento],

                           [Società ] as Società,

                           '-' as [Soc. partner doc   ))  …

      Error: Field not found - <Società >

      end if

      next

      set ErrorMode=0

      tab2:

                      LOAD [Nr.doc.] as [ID documento],

           Società  ...      and so on.

       

       

      how can i fix this?

      i also tried to load the file without labels (see below)

      tab1:

          LOAD [@1] as [ID documento],

               [@6] as Società,

       

      FROM [aa.txt]

          (txt, codepage is 1252, no labels, delimiter is '|', no quotes, header is 3 lines, filters(

      Remove(Col, Pos(Top, 1)),

      Remove(Row, Pos(Top, 2))

      ));

      but in the future the positions of the columns could change and this is not a stable solution.

       

      Thanks in advance!

      M