Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
haymarketpaul
Contributor III

Pipe Delimited File - data loading in wrong field

QV12 SR3

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

ie

What should be in Add2 (addressline2) is going into Add3

and

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

Tags (2)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Pipe Delimited File - data loading in wrong field

Try this as format spec: (txt, codepage is 1252, embedded labels, no quotes, delimiter is '|');


talk is cheap, supply exceeds demand

View solution in original post

4 Replies

Re: Pipe Delimited File - data loading in wrong field

Hi Paul,

I just reload your data (without any change), i got the result like

Capture.JPG

version : 11.2 SR9

haymarketpaul
Contributor III

Re: Pipe Delimited File - data loading in wrong field

Oh that's weird - i've just tried again (without any change) and it's still doing it wrong??

Wrong Column2.png

MVP & Luminary
MVP & Luminary

Re: Pipe Delimited File - data loading in wrong field

Try this as format spec: (txt, codepage is 1252, embedded labels, no quotes, delimiter is '|');


talk is cheap, supply exceeds demand

View solution in original post

haymarketpaul
Contributor III

Re: Pipe Delimited File - data loading in wrong field

Perfect - Thank you