topic Re: loosing characters in QlikView

loosing characters

Tue, 21 Mar 2017 13:25:17 GMT

This is my first question here, I hope anyone can help.

I have a problem creating a qvd-file based on a csv-file.

One of the fields in the csv is char-field, length=6. The second position is "J", all the others are blank.

Running my qvw, the result in the qvd is a field "J" with a length=1. All blanks are truncated.

I use the following script (maybe with wrong parameters?):

LOAD

@1 AS FIELD1,
@2 AS FIELD2,
@3 AS FIELD3, <= that’s the problem-field
@4 AS FIELD4,
@5 AS FIELD5

FROM Test.csv
(txt, codepage is 1252, no labels, delimiter is ';', msq)

;

The concerning part of the csv-file:

;" J "; …

The qvd looks this way:

Maybe someone has an idea?

Thanks a lot, Mike

Frank_Hartmann — Tue, 21 Mar 2017 15:27:10 GMT

this might be helpful:

Tue, 21 Mar 2017 16:39:09 GMT

Frank,

seems, it works

... with the little csv I tested with.

Next I will try it with the whole file (3,8 GB).

Thanx a lot!

MarcoWedel — Tue, 21 Mar 2017 23:12:02 GMT

maybe helpful:

regards

Marco