Discussion board where members can get started with QlikView.
Have an odd problem that i can't figure out.
When loading from a pipe delimted text file I have some rows where the data is going in to the wrong field
What should be in Add2 (addressline2) is going into Add3
What should be in CompanyName is going in to Add1
The only common theme i can see with the data is that the preceding field data has apostrophes within it. I have tried purging these out in the LOAD but the issue still occurs?
I've attached the offending data txt file, a qvw of the loaded data and a screenshot that hopefully highlights the issue a bit better.
Any ideas what's causing it to happen and how to fix much appreciated
Try this as format spec: (txt, codepage is 1252, embedded labels, no quotes, delimiter is '|');
View solution in original post
I just reload your data (without any change), i got the result like
version : 11.2 SR9
Oh that's weird - i've just tried again (without any change) and it's still doing it wrong??
Perfect - Thank you