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.
Retrieving data ...