topic Re: file load is incorrectly splitting a row into 2 rows in QlikView

file load is incorrectly splitting a row into 2 rows

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

I am loading a text file and noticed a problem with some of the rows. The load is splitting some of the rows into 2 rows. Is there a way to code the load to force it to load correctly?

I've tried various options through the load wizard but always see in the preview pane that the 3rd row is being split after '03/12/2016' and the remainder is treated as a 4th row.

Any suggestions?

Thanks.

Re: file load is incorrectly splitting a row into 2 rows

veidlburkhard — Thu, 17 Aug 2017 19:29:11 GMT

Hi Tony,

this is because you have a CR in your third line of text. See the picture:

You must delete this control character before loading the text.

Hope this helps

Burkhard

Re: file load is incorrectly splitting a row into 2 rows

twills12 — Thu, 17 Aug 2017 21:09:47 GMT

Thanks Burkhard, that definitely makes sense and helps.

Is that possible in the script or do I need to have the source file edited if not?

Re: file load is incorrectly splitting a row into 2 rows

veidlburkhard — Fri, 18 Aug 2017 08:41:28 GMT

I think, Tony, you have to do this in the source file. Cause QV doesn't load the CR.

Good luck

Burkhard

Re: file load is incorrectly splitting a row into 2 rows

twills12 — Mon, 21 Aug 2017 17:03:48 GMT

That's what I was afraid of. Thanks Burkhard.