topic Load from Textfile, issues with "Transformation Step" in QlikView

Load from Textfile, issues with "Transformation Step"

Wed, 29 Oct 2014 15:34:09 GMT

Hi,

I'm trying to shape up my text-file table when loading into QV.

Without using the transformation step tool the below code is generated, and working fine.

1.Works fine

When trying to load the very same table using the transformation step tool, I receive an error message:

2. Fail

Any clues?

Kind Regards,

Olle

maxgro — Wed, 29 Oct 2014 23:40:32 GMT

maybe adding at the end of the where condition

where len(trim(@1:18))>0

Mon, 03 Nov 2014 14:24:01 GMT

not working for me Im afraid

Same error message