HI, Have strange situation: some long strings are truncated by the Qlikview sql. Some of them after 430 char, some after 500 char, randomly. Any ideas?
It's possible that QlikView is hitting characters that it interprets as end of line or something. I don't actually know if it does that, mind you. If that IS a problem, a way around it would probably be to use the verbatim flag.
SET Verbatim=1; LOAD your data FROM your source; SET Verbatim=0;
I suspect that isn't it, though, as the help text only indicates that Verbatim keeps QlikView from trimming spaces, and I doubt funny characters are the problem anyway. It's just my only guess right now.
