topic Re: question about 'exists' function in QlikView

question about 'exists' function

Anonymous — Thu, 30 Apr 2015 11:03:29 GMT

Hi,

My task is to load the data on the Brands which exist in 2013. If a certain Brand existed in 2012, but doesn't exist in 2013, I want it to be excluded. I'm trying the following syntax. But it doesn't give the needed result - brands which existed only in 2012 are not excluded. Could you please help?

Source:

LOAD Brand,

Month,

[Media type],

Year

FROM

C:\Users\Larisa.Filonova\Desktop\brand_data.xlsx

(ooxml, embedded labels, table is Лист1)

where Year = 2013

;

Concatenate (Source)

LOAD *

FROM

C:\Users\Larisa.Filonova\Desktop\brand_data.xlsx

(ooxml, embedded labels, table is Лист1)

where Year = 2012 and exists(Brand)

;

Thank you in advance,

Larisa

Re: question about 'exists' function

Gysbert_Wassenaar — Thu, 30 Apr 2015 11:36:22 GMT

Looks ok to me. Did you earlier in the script load another table that also contains a field named Brand?

Re: question about 'exists' function

Anonymous — Thu, 30 Apr 2015 12:11:58 GMT

Yes, I did. Is there a solution then?

Re: question about 'exists' function

Gysbert_Wassenaar — Thu, 30 Apr 2015 12:15:33 GMT

Sure, load Brand temporarily as another field too:

Source:

LOAD Brand,

Brand as LookUpBrand,

Month,

[Media type],

Year

FROM

C:\Users\Larisa.Filonova\Desktop\brand_data.xlsx

(ooxml, embedded labels, table is Лист1)

where Year = 2013

;

Concatenate (Source)

LOAD *

FROM

C:\Users\Larisa.Filonova\Desktop\brand_data.xlsx

(ooxml, embedded labels, table is Лист1)

where Year = 2012 and exists(LookUpBrand, Brand)

;

DROP FIELD LookUpBrand;

Re: question about 'exists' function

Anonymous — Thu, 30 Apr 2015 12:38:28 GMT

It works. Thank you!