Re: Problem with Where Clausule - Qlik Community

pascos88 · ‎2016-01-18

I have this script and I have a problem with Where clausule.

The script cannot find Technologie field... why?

for Each Value in '[IWB]', '[EKZ]','[EWZ]', '[SPR]', '[KKB]', '[EWB]', '[EBL]', '[EBM]','[Terravent]'

Map1:

LOAD A as [Num of Wind Park],

replace(replace('$(Value)','[',''),']','') as Company,

B as CompanyName,

C as Technologie,

E as [Internal Name],

F as Portafolio,

G as [Name Project],

H as Shares,

I as Action,

J as Land,

K as Deparment,

L as DescriptionTecn,

N as [OEM Solar],

O as [Panel Type],

P as [Surface m2],

Q as [Num of Panels],

T as [Turbine Type],

S as [OEM Wind],

P as [Hub-height],

V as Power,

W as [Num of Turbine],

X as Layout,

Y as [Installed Capacity],

Z as [Instal Cap Pro_Rata],

AA as Commissioning,

AB as Acquisition,

AJ as Production,

AK as [Production per share]

FROM

[$(vSourceXLS)201601_EVU Plattform_Partner Portfolio_neE.xlsx]

(ooxml, no labels, header is 2 lines, table is $(Value)) where Technologie = 'Wind';

Pasquale

sunny_talwar · ‎2016-01-18

Try this as your where statement:

(ooxml, no labels, header is 2 lines, table is $(Value))

Where C = 'Wind';

Technologies is getting created during this load. You will still need to call it using it's original field name which is C.

Oleg_Troyansky · ‎2016-01-18

Hi Pasquale,

in the Where clause, you can only refer to the source field names, not the renamed fields that will be loaded as a result of your statement. Hence, in your case it's the field "C" that you need to refer to: