Not Exists()

[QlikAngel]

Hi,

I am facing issue while using where not exists function.. its not giving an optimized load.

INLINE:

LOAD * INLINE

[

ID

4271

3838

];

Dealers:

LOAD ID as DealerId,

     ID as DealerIdSurveyor,

     ID as DealerId_AXA,

     Organization as Dealer,

     //AreaId,

     //CityId ,

     StateId ,

     TC_DealerTypeId

FROM

$(vpath)\Dealers.qvd

(qvd) where not Exists (ID);

[#2]

Also, Deriving teh same field more than once causes not optimized.

[QlikAngel]

Hi Gysbert,

Its worked as Optimized.. thanks a ton.

[stevedark]

I'm surprised that renaming the one field to four different names doesn't break Optimized load - that must have been a change at some point (I'm going to have to test again!).

Another option is to do the WHERE EXISTS with the name as it appears in the QVD and then use RENAME FIELD after the event.

Steve

[mena_ricardo]

Hi, 

I think I do the same, but it doesn´t work:

REG:

LOAD
n_contr,
n_contr as n_contr_num
FROM op.QVD (qvd)
where suc=1500 or suc=5505;

AVAL_NO_REG:

LOAD
n_contr as n_contr,
Code,
suc
FROM 1500.QVD (qvd)
Where not Exists(n_contr_num);

drop table REG;

store AVAL_NO_REG into xxxxxxxxxx;
drop table AVAL_NO_REG;

Can you help me, please?

Thanks