reuse column in preceding load

[#1]

Hello,

Load
 zone as zone1,
 Year,
 (Year & '-' & zone1) as PriKey
SQL Select ............

Whenever i reload, it prompts me that zone1 doesnt not exist.
Any solution?

[#2]

hi nick,

try the following in your script

Load *, Year & '-' & zone1 as PriKey;

Load

 zone as zone1,
 Year

SQL Select ............ <div></div><div>thanks</div>

[#3]

erm... i'm afraid i can't.

I actualy did some data manipulation by if statement for zone1, so i can't use *

But thanks for the suggestion.

[Miguel_Angel_Baeyens]

Hello Nick,

Indeed the field doesn't exists (yet). Youi are renaming the field so the field would be actually renamed once the table has been loaded. Thus, your code might look like

Load zone as zone1, Year, (Year & '-' & zone) as PriKey)

Note I'm referring to the field as it is coming from the sql sentence.

Regards.