Delete a Field after load txt file.

Thu, 18 Mar 2010 12:43:56 GMT

I'm loading a txt fle with 3 fields.

If I do a load of two and on the select is refered the other one system give me an error.

The only that i can do is load 3 fields to solve the error message, but I want to delete the field that i don't need.

What is the best way and the script

Example

G12:

LOAD

C1,

FROM

txt file

(

txt, codepage is 1252, embedded labels, delimiter is ';', no quotes

)

where

C3=1

;

It give me an error because C3 is not located.

Best regards

Thu, 18 Mar 2010 14:29:48 GMT

Error from my SIDE, on select I put variable on lowercase instead uppercase

topic Delete a Field after load txt file. in QlikView