0 Replies Latest reply: Sep 27, 2012 9:04 AM by Tormod Hanstad RSS

    Reading CSV files into qlikview with unballanced quoting

    Tormod Hanstad

      In a description field of my file from oil and gas piping, they had the following:

       

      PIPE WITH FIITINGS 22"

       

      When qlikview or any other system see this, we get an unballanced quoting and all lines read after this is trunced. It is hard to get when you working wirh a couple of houndred tousand records.

       

      The only way around this in qlikview is in the parameters in the FROM stmt. you have to change from msq to noquote.

       

      /Tormod