Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
thanstad
Creator
Creator

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

0 Replies