topic reuse column in preceding load in QlikView

reuse column in preceding load

Tue, 15 Jun 2010 06:14:40 GMT

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?

reuse column in preceding load

Tue, 15 Jun 2010 06:22:22 GMT

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>

reuse column in preceding load

Tue, 15 Jun 2010 06:46:41 GMT

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.

reuse column in preceding load

Miguel_Angel_Baeyens — Tue, 15 Jun 2010 08:21:02 GMT

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.