4 Replies Latest reply: Sep 12, 2017 3:22 AM by Camille Menten RSS

    Qlik sense scripting: use of codepage & delimiter

    Camille Menten

      Dears,

       

      Very silly questions, but hey, still an apprentice :-)

       

      In scripting, for loads from excel files, I'm used to the below to identify my source data

       

      FROM

                        [$(vL.PipelineFile)]

                     (ooxml, embedded labels, header is 9 lines, table is [Incoming Pipeline])

                     where not isnull(CRM );

       

      ow I see for a part of our script:

      FROM

                  [$(vL.ExternalFundFile)]

                  (txt, codepage is 1252, embedded labels, delimiter is ';', msq)

       

      As I don't understand what this does, I can't figger out how to simply add a column from the source file to my load in Qlik.

      Can somebody explain what the above means? Thanks a lot