topic Pipe Delimited File - data loading in wrong field in QlikView

Pipe Delimited File - data loading in wrong field

haymarketpaul — Wed, 25 Nov 2020 16:16:04 GMT

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

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

Re: Pipe Delimited File - data loading in wrong field

settu_periasamy — Thu, 14 Jul 2016 15:28:02 GMT

Hi Paul,

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

version : 11.2 SR9

Re: Pipe Delimited File - data loading in wrong field

haymarketpaul — Thu, 14 Jul 2016 15:36:46 GMT

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

Re: Pipe Delimited File - data loading in wrong field

Gysbert_Wassenaar — Thu, 14 Jul 2016 15:44:30 GMT

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

Re: Pipe Delimited File - data loading in wrong field

haymarketpaul — Thu, 14 Jul 2016 15:46:42 GMT

Perfect - Thank you