Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

thanstad
New Contributor III

Reading CSV files into qlikview with unballanced quoting

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

Tags (4)
Community Browser