My field fails to reload when placed in a certain position--Why

[helen_pip]

Hello

I have written my SQL and am referencing my fields in Qlikview i.e.

LOAD

DATE,

FORENAME,

SURNAME

SQL;

Select

Date,

Forname,

Surname

from table1

However the relaod fails when I have forename in a certain place in the LOAD statement.  If I move my forename field around to the top or bottom, then reload runs O.K.

Why would this be?

Kind Regards

Helen

[jonathandienst]

Hi I dont fully understand your problem, but your query should look something like this:

LOAD

          Date As DATE,

          Forename As FORENAME,

          Surname As SURNAME

;

SQL Select

          Date,

          Forename,

          Surname

From table1

;

Hope that helps

Jonathan