QlikView Expressor: Understanding Schema Record Delimiters

    Originally published on 07-21-2011 09:00 AM

     

    When you create an expressor schema artifact for a delimited file resource, you must specify the field and record delimiters.

    Setting the field delimiter is easy. Simply view the data in the file and enter the appropriate field delimiter pattern into the Field Delimiter control. Setting the record delimiter requires a little more thought.

    For the Read File operator, enter into the Record Delimiter control the delimiter pattern that corresponds to the line delimiter specific to the operating system on which the file was written. For the Write File operator, enter the delimiter pattern that corresponds to the line delimiter specific to the operating system on which you want to read the file.

    It does not matter on which operating system the Expressor dataflow runs. Files employing the UNIX/Linux line delimiter may be processed on Windows and Windows files may be processed on UNIX/Linux.