Delete a Field after load txt file.

[#1]

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,

C2

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

[#2 · Accepted solution]

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